=sum('tally 1'!b52,'non repairable 1'!x99)

Since you're using =sum(), you don't need the +'s inside the parens.

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??

--

Dave Peterson