MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Combining 3 separate worksheets to get an overall total


Posted by Angie Dickinson on July 31, 2001 10:56 AM

Hello excel experts maybe one of you can help me.
I have 3 worksheets one for a different country. how can i combined these three worksheets to get an overall total in worksheet 4. Each worksheet is set up the same column headings the only difference is the amounts in each cell.

Thanks


Posted by Jerid on July 31, 2001 11:24 AM

Angie, you could put this formula in the cell you wish to total on sheet 4.

=SUM(Sheet1!A1,Sheet2!A1,Sheet3!A1)

Change the Sheet1, Sheet2, and Sheet3 to the names of your sheets
Change the A1 to the cells you wish to sum
Then autofill down, or across.

I hope this helps

Jerid