I am trying to figure this out and cannot seem to get it. I have a monthly worksheet that looks like this:

Sheet1:

Jan: 200
Feb: 200
Mar: 100
Apr: 100
May: 150
Jun: 100
...
...
120 rows like this (10 years)

Sheet2:

Q1: =sum(row():row()+2) **[I need this to be summing the other sheet though but based on the same rows]

Q2: =sum(row()+3:row()+5)

Q3: =sum(row()+6:row()+8)

Q4: =sum(row()+9:row()+11)

Does this make sense? If I do that then I can just copy that block of 4 lines down for each year of data and have it sum the quarterly data. Any ideas or help? Thanks.