How to create a consolidated excel worksheet?
I have 5 data sheets in one excel document, now I need to create a consolidated worksheet that summarizes the data grids from 5 sheets. How do I do it? step-by step instructions please. thanks so much
On your summary sheet, to show the total of whatever is in cell A1 on all your sheets, type this into a cell (change sheet names as necessary):
=’Sheet 1′!A1 + ‘Sheet 2′!A1 + ‘Sheet 3′!A1 + ‘Sheet 4′!A1 + ‘Sheet 5′!A1
Another way to do this is:
=SUM(’Sheet 1:Sheet 5′!A1)
This will add all the data in cell A1 from each sheet that is arranged between sheet 1 and sheet 5. (i.e if you have the sheet-tabs arranged: sheet1, sheet3, sheet5, sheet2, sheet4, then this formula will only total sheet1, sheet3, and sheet5.)
To show the total of column B1:B5 from sheet1:
=SUM(’sheet1′!B1:B5)
If that doesn’t completely answer your question, just add more details.
July 15th, 2009 at 2:08 am
On your summary sheet, to show the total of whatever is in cell A1 on all your sheets, type this into a cell (change sheet names as necessary):
=’Sheet 1′!A1 + ‘Sheet 2′!A1 + ‘Sheet 3′!A1 + ‘Sheet 4′!A1 + ‘Sheet 5′!A1
Another way to do this is:
=SUM(’Sheet 1:Sheet 5′!A1)
This will add all the data in cell A1 from each sheet that is arranged between sheet 1 and sheet 5. (i.e if you have the sheet-tabs arranged: sheet1, sheet3, sheet5, sheet2, sheet4, then this formula will only total sheet1, sheet3, and sheet5.)
To show the total of column B1:B5 from sheet1:
=SUM(’sheet1′!B1:B5)
If that doesn’t completely answer your question, just add more details.
References :