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