Thread: sumproduct last 30 rows
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default sumproduct last 30 rows
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))


"Nick Krill" wrote:

How can I use sumproduct on the last 30 rows of a database whose number of
rows changes daily?
Reply With QuoteReply With Quote