Managing the data in a large Excel workbook can be overwhelming. Often, a large workbook will consist of multiple sheets that organize different tables and have different calculations. To get a handle on a large workbook, you can create a summary sheet that abstracts and totals information from other sheets. Excel lets you accomplish this by creating a standard formula.
Open the Excel workbook that contains several sheets you want to total.
Click the sheet name tab at the bottom of the Excel workbook that you want to hold the final total. Click an empty cell within that sheet where you want to see the total. Enter an equal sign.
Click the tab for the next sheet. Click the cell on the second sheet that you want included in the total. Enter a plus sign.
Click the tab for the third sheet. Click the cell on the third sheet that you want to add to the total. Continue entering a plus sign and clicking on cells in each sheet that you want to include in the total.
Press "Enter" when you have added all the cells from the different sheets. You should see the total on the first sheet where you started your formula. The formula should look something like this:
Tips & Warnings
- It's useful to calculate a subtotal on each sheet first if each sheet contains a range of cells you want to total. To do so, go to a blank cell on each sheet and enter "=SUM(range of cells)" replacing "range of cells" with a range, such as "A2:A25." Once you have a subtotal, you can use that cell to add to the grand total on the original sheet.
- Photo Credit Burke/Triolo Productions/Brand X Pictures/Getty Images
Excel 2007: How to Import Data From One Excel Sheet to Another
In computing terms, a "spreadsheet" is a type of large table that is used to display information. Microsoft Excel 2007 is just...
How to Link Data to Another Spreadsheet in Excel
If you need to use several spreadsheet files to keep your data current, try linking cells of one spreadsheet to another. This...
How to Use Subtotals & Totals in an Excel Spreadsheet
Get totals and subtotals in an Excel spreadsheet by using the auto sum function on the toolbar menu and specifying which cells...