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

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

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

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.



geld wrote:

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

--

Dave Peterson

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

=SUM(Sheet1:Sheet3!A1)

Adjust to suit


"geld" wrote:

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

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

Thanks for the help... I actually remembered how to complete this task just
after posting, but I do appreciate the prompt responses.
--
thanks,
geld


"Teethless mama" wrote:

=SUM(Sheet1:Sheet3!A1)

Adjust to suit


"geld" wrote:

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