MrExcel Publishing
Your One Stop for Excel Tips & Solutions

sum totals


Posted by Dana A on November 01, 2001 9:43 AM

how do I add totals from sheet 1 and sheet 2 together?


Posted by Jack on November 01, 2001 9:54 AM

Sheet 1 and Sheet 2
Sheet 1 cell A1 = 100
Sheet 2 cell A2 = 50
Sheet 2 cell type exactly this =A1+Sheet1!A1

Answer 150

Adjust as reqd

Posted by EDDIE G on November 01, 2001 9:55 AM

=SUM(D9+Sheet2!C7) OR WHATEVER CELLS CONTAIN THE TOTALS

Posted by IML on November 01, 2001 10:08 AM

You can also use the following format, if you want to say capture the total of cell A1 across sheets:
=SUM(Sheet1:Sheet2!A1)

Excel is pretty flexible at letting you point around to what you want to include in a formula, so if you are getting caught up on syntax, play around with it a little. Just be sure to hit an operater or enter after you've selected the cell you want to include.

good luck