Hi! I want to sum the following:

On Sheet1 I have column of data by year.

On Sheet2 I want to add each year:
Cell 1 - Sum(Sheet1!C1:C12)
Cell 2 - Sum(Sheet1!C1+12:C12+12)

I want to do this so I do not have to keep going back and finding the exact
cell. Can some one please help?

Thanks.

..... Sheet3 should be Sheet1 !

"dipsy" wrote:

Hi! I want to sum the following:

On Sheet1 I have column of data by year.

On Sheet2 I want to add each year:
Cell 1 - Sum(Sheet1!C1:C12)
Cell 2 - Sum(Sheet1!C1+12:C12+12)

I want to do this so I do not have to keep going back and finding the exact
cell. Can some one please help?

Thanks.

=SUM(OFFSET(Sheet3!$C$2,(ROW()-ROW($A$2))*12,0,12))


assumes sheet2 data starts in row 2. Change $A$2 if required



"dipsy" wrote:

Hi! I want to sum the following:

On Sheet1 I have column of data by year.

On Sheet2 I want to add each year:
Cell 1 - Sum(Sheet1!C1:C12)
Cell 2 - Sum(Sheet1!C1+12:C12+12)

I want to do this so I do not have to keep going back and finding the exact
cell. Can some one please help?

Thanks.

Enter this *anywhere*, and copy down as needed:

=SUM(INDEX(Sheet1!C:C,12*ROWS($1:1)-11):INDEX(Sheet1!C:C,12*ROWS($1:1)))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"dipsy" wrote in message
...
Hi! I want to sum the following:

On Sheet1 I have column of data by year.

On Sheet2 I want to add each year:
Cell 1 - Sum(Sheet1!C1:C12)
Cell 2 - Sum(Sheet1!C1+12:C12+12)

I want to do this so I do not have to keep going back and finding the
exact
cell. Can some one please help?

Thanks.