MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Totals from different worksheets


Posted by Joe Fan on January 13, 2002 7:13 PM

I have a workbook with 3 sheets in it with a total on each sheet. I would like the last sheet to add the totals from each sheet how can i do this?


Posted by Jacob on January 13, 2002 7:19 PM

Hi

Lets say the totals are in A1 on sheet1-sheet3 modify as needed

=Sheet1!A1+Sheet2!A1+Sheet3!A1

will total all three fields.

HTH

Jacob