If I add a new sheet that is formatted just like the other sheets in the
workbook will my totals formula add the new sheet?

Depends on what your formulas are.

This may help (or not):

Insert a couple of worksheets to surround your existing worksheets.

Call the one at the far Left, "Start" (w/o the quotes).
Call the one at the far right, "End" (w/o the quotes).

Then put the total sheet outside that "sandwich" of worksheets.

And use a formula like:
=sum(Start:End!g9)

You can drag sheets in and out of that sandwich to play what-if games.

And you can insert new sheets within that sandwich, too.

mattshoppe wrote:

If I add a new sheet that is formatted just like the other sheets in the
workbook will my totals formula add the new sheet?

--

Dave Peterson

Only if it is included in the range of sheets to be totalled in your 3D formula.

Best method for this is to insert a dummy sheet at beginning and name it Start

Insert one at end and name it End

3D reference will be =SUM(Start:End!cellref)

Any new sheets inserted between Start and End sheets will be included in your 3D
reference.


Gord Dibben MS Excel MVP

On Thu, 1 Feb 2007 13:33:02 -0800, mattshoppe
wrote:

If I add a new sheet that is formatted just like the other sheets in the
workbook will my totals formula add the new sheet?