sum one cell from multiple worksheets

A

abrusey

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

GHawkins

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)
 
G

Gord Dibben

=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
 
A

abrusey

Thank you both for the assistance!!!

Gord Dibben said:
=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
Click to expand...
 
Top