Remember Me?

#1
November 29th 04, 04:45 PM
 SKB Posts: n/a
Calculating rolling sums

I have a year table and enter monthly amounts. I need to calculate the last
three months that have data in the cells. What formula do I use?

#2
November 29th 04, 05:07 PM
 Frank Kabel Posts: n/a

Hi
post some example rows.

--
Regards
Frank Kabel
Frankfurt, Germany

"SKB" schrieb im Newsbeitrag
...
I have a year table and enter monthly amounts. I need to calculate

the last
three months that have data in the cells. What formula do I use?

#3
November 29th 04, 05:45 PM
 SKB Posts: n/a

The data is in table form listing work hours and the percentage of time spent
on each catagory permonth.
jan feb mar april may jun july etc. three month total
12 month total
75 84 93 71
I have all of the months in the table, but only want to calculate the last
three months each month. So in the example above, I have data entered for the
first 4 months. I want to calculate the last 3 months and not include the
future months. I also want to calculate ytd. The raw data is
imported/manually entered.

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

 Similar Threads Thread Thread Starter Forum Replies Last Post Jamesy Excel Discussion (Misc queries) 1 January 10th 05 04:39 PM Jamesy Excel Discussion (Misc queries) 3 January 10th 05 04:03 PM J Dizzle Fizzle Excel Discussion (Misc queries) 1 December 31st 04 08:47 PM Jens Eichelbaum Excel Worksheet Functions 2 November 23rd 04 03:10 AM ryangruhn Excel Worksheet Functions 0 November 3rd 04 08:42 PM

All times are GMT +1. The time now is 03:37 AM.