MS Excel Help: How to Sum Different Sheets
Microsoft Excel can make use of a large number of sheets in a workbook with each sheet acting as a completely independent standalone spreadsheet. Excel also has the ability to reference sheets that reside in different workbooks, which allows the spreadsheet to draw and manipulate information from millions of individual cells. You can reference a cell that resides in a different sheet or workbook when using Microsoft Excel to create overview spreadsheets or sheets for printing or presentation.
Launch Microsoft Excel and open the workbook that contains the cells that need to be referenced. Open additional workbooks as desired to make those cells available for reference as well.
Navigate to the cell which is to contain the sum from other sheets and click once in the cell to highlight it.
Press the "=" key to begin to create a formula in the selected cell.
Navigate to the sheet or workbook that contains the first item to be included in the sum and click on the cell which contains the first number to be added.
Press the "+" key and then navigate to the sheet or workbook that contains the next item to be included in the sum and click on the cell which contains the next number to be added. Repeat until every cell you want to include in the total has been clicked on, and then press "Enter" to save the formula.
Tips & Warnings
- Create a subtotal cell on each sheet to easily reference the totals for a range of cells in the sum formula.
- Once a reference to another workbook has been created the workbooks cannot be moved or renamed without breaking the reference.
References & Resources
- Microsoft Office: Overview of Connecting to (Importing) Data
- Microsoft Office: Get to Know Excel 2010: Create Formulas
- Microsoft Office: Getting Started with Excel
- Microsoft Office: Quick Start: Edit and Enter Data in a Worksheet
- Microsoft: Import Financial Data into Excel from Various Sources
- Microsoft Office: Office 2010 for Business: Download a Free Trial
- Microsoft Download Center: Office 2010: Product Guides