Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
I have searched to message boards and can't quite find what i'm looking for. I'm trying to keep a 12 month running tally (When I enter the information for a new month, the oldest month drops out keeping only 12 months of information) I currently have a worksheet with 2 matrixes of information. A5-A16 holds the months of 2008 (Jan, Feb,...) and E5-E16 holds the monthly totals. A22-A33 hold the months of 2009 and E22-E33 holds the montly totals. In a cell (F39 on my worksheet) I'd like to keep the 12 month rolling total such that when I enter the data for June, the total in F39 will update for the period of Jun09-Jul08. Thanks for any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
rolling 3 month tracking | Excel Discussion (Misc queries) | |||
Rolling 13 Month Charts | Charts and Charting in Excel | |||
12 month Rolling Total | Excel Worksheet Functions | |||
How do I set up 12-month rolling month cells in excel? | Excel Discussion (Misc queries) | |||
3 month rolling chart | Charts and Charting in Excel |