counting dynamic end of multiple arrays

andre

New member
Joined
Aug 21, 2011
Messages
7
Reaction score
0
Points
0
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....
 
Try this, =SUM(OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),1)) assuming values are in sheet1 in column A
 
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))
 
Without OFFSET

=SUM(INDEX(A:A,MATCH(99^99,A:A)-9):INDEX(A:A,MATCH(99^99,A:A)))
 
Problem solved :) you are the man bob...........thanks for all replies
 
Back
Top