| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create database in excel? | New Users to Excel | |||
| quickly create extra copies of a worksheet template in a workbook | Excel Worksheet Functions | |||
| Rolling sums | Excel Discussion (Misc queries) | |||
| need to create a formula to create a timesheet but haven't a clue | Excel Discussion (Misc queries) | |||
| Create a tabular control | Excel Discussion (Misc queries) | |||
Linear Mode
