Click the cell where you want to enter the function and type "=sum(" minus
the quotes. Click on the tab for the first worksheet you want to be
referenced, hold down the SHIFT key, and click on the other tab(s) you want
to reference. After all tabs are selected, select the cell or range you want
to reference (such as A1) and press Enter. Your formula will end up looking
something like this:

=SUM(Sheet1:Sheet3!A1)

"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!