# Thread: counting dynamic end of multiple arrays

1. ## counting dynamic end of multiple arrays

hi. can anyone help me with this; every hour new numbers are added in six arreys. there are now 1348 rows and new are coming every hour....how do i count the last 10 entries? i am filling in the new numbers in a form....

2. Try this, =SUM(OFFSET(Sheet1!\$A\$1,0,0,COUNTA(Sheet1!\$A:\$A),1)) assuming values are in sheet1 in column A

3. ## Note to self:

Doh!, should read the entire question properly!

Use this: =SUM(OFFSET(A1,MATCH(1E+30,A:A)-1,1,-10,1))

EDIT: for use in another sheet: =SUM(OFFSET(Sheet1!A1,MATCH(1E+30,Sheet1!A:A)-1,1,-10,1))

4. Without OFFSET

=SUM(INDEX(A:A,MATCH(99^99,A:A)-9):INDEX(A:A,MATCH(99^99,A:A)))

5. Originally Posted by Bob Phillips
Without OFFSET

=SUM(INDEX(A:A,MATCH(99^99,A:A)-9):INDEX(A:A,MATCH(99^99,A:A)))
Smarter way Bob!

6. Problem solved :-) you are the man bob...........thanks for all replies

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•