On Jan 20, 4:18*pm, renegade
wrote:
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- Hide quoted text -

- Show quoted text -

Try this modified version:

=SUM(OFFSET(Munka1!$A2,0,(LEFT(A1)*3-3)+MATCH("*"&RIGHT(A1,2),Munka1!
1:1,0)-1,1,3))

Regards,
Stefi