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
