=SUM(Sheet1:Sheet11!A1)

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!A1) will cover all sheets in between no matter what the name.


Gord Dibben MS Excel MVP


On Wed, 23 Aug 2006 12:39:02 -0700, abrusey
wrote:

Hello!

Does anyone know of a quick way to sum one cell (for ex. A1) for all
worksheets in the workbook (say there are 10 total + 1 Summary worksheet) on
the summary worksheet?

Please let me know if the question needs additional clarification.

thanks!