S
Stephen White
Is there a function that will add the values of the same cell in several
worksheets?
Suppose I have 52 worskheets (one for each week in the year) and I want
to add the values in cell D3 on each and place the result in another
worksheet, is there a function that will save me having to type
='Sheet1'!D3+'Sheet2'!D3+'Sheet3'!D3+'Sheet4'!D3+'Sheet5'!D3+'Sheet6'!D3+'Sheet7'!D3
and so on?
I tried =SUM('Sheet1'!D3:'Sheet52'!D3) but it looks as though the result
is the sum of a block of cells spanning the 52 sheets.
What I am after is something like =SUM('Sheet1'!:'Sheet52'!,D3).
worksheets?
Suppose I have 52 worskheets (one for each week in the year) and I want
to add the values in cell D3 on each and place the result in another
worksheet, is there a function that will save me having to type
='Sheet1'!D3+'Sheet2'!D3+'Sheet3'!D3+'Sheet4'!D3+'Sheet5'!D3+'Sheet6'!D3+'Sheet7'!D3
and so on?
I tried =SUM('Sheet1'!D3:'Sheet52'!D3) but it looks as though the result
is the sum of a block of cells spanning the 52 sheets.
What I am after is something like =SUM('Sheet1'!:'Sheet52'!,D3).