Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Fiscal year total from running 12 months
I maintain data for the previous twelve months in Excel 2002. I want to
calculate statistics based on fiscal year data, which is a changing subset of the running twelve month data. How can I do this without manually changing formulas each month? |
#2
|
|||
|
|||
Data ranges are what exactly?
-- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- wrote in message ... I maintain data for the previous twelve months in Excel 2002. I want to calculate statistics based on fiscal year data, which is a changing subset of the running twelve month data. How can I do this without manually changing formulas each month? |
#3
|
|||
|
|||
Nothing complex. For example a row of months (12), currently Feb 04 through
Jan 05 with sales figures below. I need to total the current fiscal year to date as well as the 12 month period. Fiscal year to date would be Sep 04 through Jan 05. So next month I delete Feb 04 at beginning of row, copy March 04 through Jan 05 one column to the left, and add Feb 05 at the end. Fiscal year to date then has to add one more cell from 'inside' this range. Now I do it manually for multiple types of data. Obvioulsy, automating would be a time saver! Thanks "Ken Wright" wrote in message ... Data ranges are what exactly? -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- wrote in message ... I maintain data for the previous twelve months in Excel 2002. I want to calculate statistics based on fiscal year data, which is a changing subset of the running twelve month data. How can I do this without manually changing formulas each month? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I calculate total of months that have passed? | Excel Discussion (Misc queries) | |||
timesheet with running total of overtime | Excel Worksheet Functions | |||
keep a running total of my formula results after each (F9) | Excel Discussion (Misc queries) | |||
how do I keep a running total of my bills? | Charts and Charting in Excel | |||
how to calculate total months from month/year | Excel Discussion (Misc queries) |