Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 20

Rolling Calculations

I have a spread sheet with three years of monthly data. I need to calculate
for a rolling twelve month total each month.
(i.e.)
sum data in columns for (Jan2006 - Dec2006),
sum data in columns for (Feb2006. - Jan2007),
sum data in columns for (Mar2006. - Feb2007, etc.)

--progressing the total along twelve months each new month. Any ideas
--
Motaad

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Rolling year calculations	louiscourtney	Excel Discussion (Misc queries)	9	July 12th 07 04:22 PM
Rolling 12 week calculations	Throwme A Frigginbone	Excel Worksheet Functions	2	January 9th 07 09:37 AM
rolling	dustin	Excel Worksheet Functions	2	August 3rd 06 10:17 PM
Rolling 3 mth Average	dallin	Excel Worksheet Functions	1	November 22nd 05 04:10 PM
Z Chart i.e. top rolling annual bottom rolling monthly middle cum.	wat prin	Excel Worksheet Functions	0	January 28th 05 03:43 PM

All times are GMT +1. The time now is 04:21 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us