Sum same cell/range of multiple worksheets within a workbook...

[Guest]

I am trying to sum a cell from multiple worksheets within a workbook to
receive a total of all the worksheets. Isn't there a way to do this without
selecting each worksheet cell (i.e. sum(worksheet1'!A1, worksheet2'!A1, ...)?

 

[Dave Peterson]

Same cell in each worksheet?

If yes, then insert a couple of worksheets to surround your existing worksheets.

Call the one at the far Left, "Start" (w/o the quotes).
Call the one at the far right, "End" (w/o the quotes).

Then put the total sheet outside that "sandwich" of worksheets.

And use a formula like:
=sum(Start:End!a1)

You can drag sheets in and out of that sandwich to play what-if games.

 

[Guest]

=SUM(Sheet1:Sheet3!A1)

Adjust to suit