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


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


will total all three fields.