| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Write an excel 'sum' formula for a certain # of columns
I am trying to build a rolling spreadsheet based on days. I want to have a
total for the trailing 30 days, but keep all the information that is older than 30 days. If I lock the formula, and add new days it keeps the original 30 day calculation, instead of adding on 1 new day and dropping off the oldest day of the 30. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| a simple 'sum' formula is not adding all of the data in range | Excel Discussion (Misc queries) | |||
| how to put 'SUM' formula in VB after picking up certain names and their bonus | Excel Discussion (Misc queries) | |||
| 'SUM' Tables | Excel Worksheet Functions | |||
| How do I write a VBA code in excel that will compare two columns . | Excel Worksheet Functions | |||
| How can I write vertically in some columns on an Excel spreadshee. | Charts and Charting in Excel | |||
Threaded Mode
