MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Don on February 08, 2002 9:25 AM


Is there a way to add values that are in the same cell on multiple worksheets without having to go to each sheet and selecting the cell?


Posted by IML on February 08, 2002 9:31 AM

Posted by Curtis on February 08, 2002 1:03 PM

Try this -
On Sheet 1, Select a cell where you want the result to be, press the sum key, hold down the shift key and highlight the pages you want to sum, then highlight that cell. The formula looks like: =SUM(Sheet2:Sheet3!A1). It should work.