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


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:

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