| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
12 month Rolling Total
Can someone please help???
What formula do you use to keep a 12 month rolling total of data for example: August 2005 3.0 Sep Oct Nov Dec Jan 2006 Feb Mar Apr May Jun Jul Aug September 2006 2.5 When adding the data from month to month it changes all data to the most current so all other months will be 2.5 is there a formula I can use to stop this from happening? Hopeful |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create a rolling 6 month average? | Excel Discussion (Misc queries) | |||
| Old Lotus Sub Total & Grand Total formula | Excel Discussion (Misc queries) | |||
| 3 month rolling chart | Charts and Charting in Excel | |||
| rolling time period | Excel Worksheet Functions | |||
| How to calculate total interest on 12 month loan with early payments | Excel Worksheet Functions | |||
Linear Mode
