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.

Step

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.

Step

Navigate to the cell which is to contain the sum from other sheets and click once in the cell to highlight it.

Step

Press the "=" key to begin to create a formula in the selected cell.

Step

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.

Step

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.