How to add the same cell on multiple spreadsheet?

[Guest]

If I have multiple spreadsheets with a subtotal on the same cell on each
sheet, say cell "A1". How do I add all these numbers up without clicking on
each cell to add to the Sum function?

 

[Guest]

If those sheets are contiguous, say sheets 1 through 6, use

=SUM(Sheet1:Sheet6!A2)

 

[Paul B]

Derrard, something like this,

=SUM(Sheet1:Sheet3!A1)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Biff]

Hi!

Make sure all the sheets needed are contiguous:

Tab order:

Summary | Sheet1 | Sheet2 | Sheet3 |


Then:

=SUM(Sheet1:Sheet3!A1)

Or, this is a popular method:

Enter an empty sheet named Start before Sheet1 and another empty sheet named
End after Sheet3:

Summary | Start | Sheet1 | Sheet2 | Sheet3 | End |

Then:

=SUM(Start:End!A1)

Any sheets between Start and End will be included in the Sum.

Biff