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....
 

Simon Lloyd

Administrator
Joined
Apr 2, 2011
Messages
401
Reaction score
0
Points
0
Location
Manchester, England
Excel Version(s)
Excel 2016
Try this, =SUM(OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),1)) assuming values are in sheet1 in column A
 

Simon Lloyd

Administrator
Joined
Apr 2, 2011
Messages
401
Reaction score
0
Points
0
Location
Manchester, England
Excel Version(s)
Excel 2016
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))
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
Without OFFSET

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

andre

New member
Joined
Aug 21, 2011
Messages
7
Reaction score
0
Points
0
Problem solved :) you are the man bob...........thanks for all replies
 
Top