Many thanks for your reply. What I need would be some flexibility, so the
"2001" was simply an example... so I would need a function which allows me to
aggregate monthly data from one sheet to qrtly data in another... so Jan,
Feb, and Mar-99 data would be summed up as 1Q-99 data in a separate sheet...
thanks!

"Stefi" wrote:

If data to be summed are in row2, sheet1, then

=SUM(OFFSET(Sheet1!$A2,0,(LEFT(A1)*3-3)+(RIGHT(A1,2)-1)*12,1,3))

provided that years really begin with 01.

--
Regards!
Stefi



€žrenegade€� ezt Ã*rta:

I have some monthly data in one sheet which I wish to transfer and aggregate
to another sheet at a quarterly level. I couldn't figure out if sumif
function would work here, or is any other methods? E.g.
sheet 1 contains (and continue for many years):
Jan-01 Feb-01 Mar-01 Apr-01 May-01 Jun-01 Jul-01 Aug-01

sheet 2 contains (and continue for many years):
1Q01 2Q01 3Q01

Thanks