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

G

geld

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, ...)?
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top