Thread: How would I track a rolling set of 30 cells?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default How would I track a rolling set of 30 cells?
=SUMPRODUCT(--(A2:A100=TODAY()-30),B2:B100)


"CJ Barnes" wrote:

I am trying to have a cell show me a sum for the past 30 days, updated daily.
The group of the 30 cells I'm summing will need to adjust down one cell
daily.
Reply With QuoteReply With Quote