If your sheets have unique names, insert a new dummy sheet at beginning. Name
it Start.

Insert another dummy sheet at end. Name it End.

=SUM(Start:End!B52) will cover all sheets in between no matter what the name or
spaces in those names.


Gord Dibben MS Excel MVP

On Wed, 23 Aug 2006 13:58:02 -0700, desperate measures
wrote:

ok
i tried that, but its not quite working... it may have to do with the fact
that my sheets have been renamed? they dont actually say Sheet 1, Sheet 2,
etc...
i tried entering your formula with the actual names of the sheets but it
keeps giving me a reference error.
Then it tells me that i should enclose the names of the sheets in single
quotation marks (i.e., =sum('sheet1'!b52+'sheet2'!b52), etc... but it still
gives me a reference error.
Also, i should mention that the names of my sheets have spaces in them,
particularly like this: Tally 1, Tally 2, etc... other sheets are named
NonRepairable 1, Repairable 1, etc...
help??

Gord Dibben MS Excel MVP