If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Dsum or other method to calculate running total spend. | PETER | Using Forms | 8 | December 13th, 2004 04:53 PM |
Getting Fiscal Year instead of Calendar Year | Keena | Setting Up & Running Reports | 1 | October 1st, 2004 02:55 PM |
Running Total | Sherry Hays | General Discussion | 1 | August 31st, 2004 07:50 PM |
Fiscal Year Calculations | Loretta | Worksheet Functions | 5 | August 19th, 2004 09:05 PM |
Running Total Question | r. howell | Running & Setting Up Queries | 4 | August 18th, 2004 11:25 PM |