create a rolling sum??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to create a rolling sum always taking the last 30 entries(cells) and
adding them up. Basically to keep an accurate "last 30/60/90 days sum" is
there a formula to do this?? using dates or just cells?
 
How about

=SUMIF(A4:A17,">"&D1,B4:B17)

where A4:A17 contain the dates, D1 contains the date 30/60/90 days ago and
B4:B17 contain the data you want to sum.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trailing 30 days sum calculation with excel 1
get a rolling sum between current date - 30 days 2
Time Sum in Excel 1
Syntax help with date calculation 1
sum of multiple rows 2
Create a complex formula 1
Rolling date looking 30 Days past 2
Hours and sum of hours 2

Back
Top