How do I add (=Sum) the same cell for multiple sheets (103)

  • Thread starter How do I sum sheets
  • Start date
H

How do I sum sheets

How do I add (=Sum) the same cell for multiple sheets (103). I don't want to
use the +sum(sheet1,sheet2,etc) 103 times.
 
D

Dav

If it is all sheets =SUM(Sheet1:Sheet3!G1) would work if for exampl
sheet1 is the first sheet and sheet3 the last sheet

Regards

Da
 
G

Gord Dibben

=SUM(Sheet1:Sheet103!C34) entered on Sheet104

Even better is to insert a new dummy sheet at left and a new dummy sheet at
right-end of other sheets.

Name them Start and End

Formula =SUM(Start:End!C34)

Any new sheets can be inserted between these two dummy sheets.

Now it doesn't matter what the intervening sheets are named.


Gord Dibben MS Excel MVP

On Mon, 24 Apr 2006 07:41:02 -0700, How do I sum sheets <How do I sum
How do I add (=Sum) the same cell for multiple sheets (103). I don't want to
use the +sum(sheet1,sheet2,etc) 103 times.
Click to expand...

Gord Dibben MS Excel MVP
 
Top