MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Adding cells in different worksheets


Posted by Mark Watford on November 15, 2001 5:59 AM

I need to sum the same cell in several worksheets.
EX: =(recap1!A4+recap2!A4+recap3!A4etc.) How can you do this in a easier format. There are applications where there may be fifty worksheets.


Posted by Mark Watford on November 15, 2001 7:14 AM

I see that the previous question was the same as mine. Thanks for the solution Charles.

Posted by Joe Was on November 15, 2001 7:31 AM

If I am clear on what you want:

=SUM('Sheet1'!A1:A4,'Sheet2'!A1:A5)
or
=SUM(Range_Name1,Range_Name2)

You can append ranges in a SUM if you attach each range with a "," the syntax for indicating which sheet the range is on is " 'Sheet1'! " single quote the sheet tab name end with an exclamation mark then indicate the range. If more than one range is used attach each reference with a comma. JSW