How can I use sumproduct on the last 30 rows of a database whose number of rows changes daily?
N Nick Krill Jul 3, 2007 #1 How can I use sumproduct on the last 30 rows of a database whose number of rows changes daily?
V vezerid Jul 3, 2007 #2 Assuming your headings are in row 1 and data start from row 2 and down. To sum column C:C, one way: =SUMPRODUCT(OFFSET(C1,COUNTA(C:C)-29,0,30,)) HTH Kostis Vezerides
Assuming your headings are in row 1 and data start from row 2 and down. To sum column C:C, one way: =SUMPRODUCT(OFFSET(C1,COUNTA(C:C)-29,0,30,)) HTH Kostis Vezerides
T Teethless mama Jul 3, 2007 #3 Assume your data in column A and header in row1, and no "blank" cells in between the data =SUM(OFFSET(A2,COUNT(A:A)-1,,-30,1))
Assume your data in column A and header in row1, and no "blank" cells in between the data =SUM(OFFSET(A2,COUNT(A:A)-1,,-30,1))
