MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Newby Question Sum Worksheets


Posted by Charles Walton on November 15, 2001 5:57 AM

How can I sum worksheets like Jan through Dec without adding them one by one and putting the sum in worksheet called Total?

Can I use range names in SUM like SUM(Jan!Expenses:Dec!Expenses) in a worksheet call TOTAL, if Expenses are located in diffent cell locations on the worksheets?

Sorry for such a simple question.


Posted by Dan on November 15, 2001 6:42 AM

Not sure what you mean by "sum worksheets." Do you mean you want to sum every value in the worksheet in to a single cell in worksheet Total?

The Sum command requires you to specify what cells, or range, you need to sum. If you need to sum every cell in multiple worksheets try:
=SUM(Jan:Dec!1:65536)

Assuming that these worksheets and your Total worksheet is located in the same workbook. Let me know if that isn't what you need. HTH.

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

Re: Question Sum Worksheets(Appended SUM)

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