ExcelBanter - create a rolling sum??

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - create a rolling sum?? (https://www.excelbanter.com/excel-worksheet-functions/102839-create-rolling-sum.html)

dustin

create a rolling sum??

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?

MarkN

create a rolling sum??

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.
--
Hope this helps,
MarkN

"dustin" wrote:

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?

All times are GMT +1. The time now is 09:57 PM.