Remember Me?

#1
February 14th 06, 08:04 PM posted to microsoft.public.excel.misc
 jetlag Posts: n/a
Convert monthly data into quarterly data?

Does an easy way exist to convert a column of monthly data into a column of
quarterly data (average of months in the quarter)?
THANKS!

#2
February 14th 06, 09:50 PM posted to microsoft.public.excel.misc
 bpeltzer Posts: n/a
Convert monthly data into quarterly data?

You might try this:
=SUM(OFFSET(\$M\$3,ROW()*3-9,0,3,1))
Replace \$M\$3 with the cell address of the first month's data. Replace the 9
with 3*the row number of that first month's data (my example was in row 3;
3*3=9). Autofill that formula down through three more rows.
HTH. --Bruce

"jetlag" wrote:

Does an easy way exist to convert a column of monthly data into a column of
quarterly data (average of months in the quarter)?
THANKS!

#3
March 15th 06, 03:41 AM posted to microsoft.public.excel.misc
 jetlag Posts: n/a
Convert monthly data into quarterly data?

Works like a charm... thanks, a thousand thanks!

"bpeltzer" wrote:

You might try this:
=SUM(OFFSET(\$M\$3,ROW()*3-9,0,3,1))
Replace \$M\$3 with the cell address of the first month's data. Replace the 9
with 3*the row number of that first month's data (my example was in row 3;
3*3=9). Autofill that formula down through three more rows.
HTH. --Bruce

"jetlag" wrote:

Does an easy way exist to convert a column of monthly data into a column of
quarterly data (average of months in the quarter)?
THANKS!

 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 Tom Excel Discussion (Misc queries) 9 October 31st 05 11:28 PM Moses Excel Discussion (Misc queries) 2 September 7th 05 11:13 PM baz Excel Worksheet Functions 7 September 3rd 05 03:47 PM sansk_23 Excel Worksheet Functions 3 May 2nd 05 09:51 AM Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM

All times are GMT +1. The time now is 06:25 PM.