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
