Dear all,
I'm new in the forum so please forgive me if my question is too obvious.
I of course did some research on this forum before posting.
I have monthy entries from 1993 to 2008 and I would like to get the quarterly values for each column.
Basically every 3 rows I would like to insert in the first column 'q quarter of year yyyy' and in the other columns the sum of each corresponding values.
I wonder if I should do that with excel formulas or use a macro. My knowledge of excel is limited, I can do that by importing the file into a db and calculate it but maybe it is faster using excel.
I attach an sample in case
thank you very much for your help!
Sarah
hi,
Have you considered using a pivot table (PT) to summarise your data?
Here's a good site with links that explaining PT's:
http://www.peltiertech.com/Excel/Pivots/pivotlinks.htm
& an actual example of using a PT to report on quarterly info:
http://www.contextures.com/xlPivot07.html#Dates
hth
Rob
Rob Brockett
Kiwi in the UK
Always learning & the best way to learn is to experience...
hi Crystaldew,
try this formula,
this will give you the sum of the 1st quarter, then change bold figure to either 2,3 or 4 for each of the quarters.=SUMPRODUCT((YEAR($A$2:$A$189)=$J3)*(ROUNDUP(MONTH($A$2:$A$189)/3,0)=1)*($B$2:$E$189))
hope it helps
reg
Last edited by reggie1000; 10-01-2008 at 11:03 AM.
Try this
I'm sure it's what you want
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks