Adding cells on worksheets

[Ian Fareham]

Hi, I want to add the same cell from each worksheet within
a range of say 10 worksheets in the same document. I know
I can go to each sheet and select the cell and add it
maunally to the next sheet cell etc but there has to be a
shortcut as one of my documents has over 100 sheets! Say I
ant to add A1 sheet 1 to A1 sheet 2 etc HELP!

 

[Randall Roberts]

use this formula

=SUM(Sheet1:Sheet2!A1)

sheet1 is the name of your fist sheet
sheet two is the name of your last sheet

Randall Roberts

 

[Gord Dibben]

Ian

=SUM('Sheet1:Sheet100'!A1)

If your sheets are not numbered consecutively or have unique names, the
easiest method is to insert a new worksheet at start and one at end.

Then =SUM('start:end'!A1) to SUM all A1's on all sheets.

Gord Dibben XL2002