Sum

D

Dave Peterson

I like this technique...

Create two new worksheets--one to the far right and one to the far left.

Call them Start and End

Then using a sheet (Summary) that is outside this "sandwich" of worksheets:

=Average(start:end!A1)

Then you can drag sheets in and out of that sandwich to play what if games.

I'd put a couple of notes on each of these sheets:

"don't delete this sheet!"

And protect the worksheet so that people don't use it for real data.
 
G

Gord Dibben

=SUM(Sheet1:Sheet23!C34)

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
 
Top