How to Sum Across Multiple Sheets in Excel

To sum across multiple sheets in Excel, you can use the 3D referencing formula. The 3D referencing allows you to perform calculations using data from multiple worksheets. In this case, we'll show you how to use the SUM function to sum values across multiple sheets.

Follow these steps to sum across multiple sheets in Excel:

1. Open your Excel workbook and ensure you have at least two worksheets with the values you want to sum.
2. Click on the sheet where you want to display the total sum.
3. Click on the cell where you want the total sum to appear.
4. Enter the following formula: =SUM(Sheet1:SheetN!cell_address).
   • Replace Sheet1 with the name of the first sheet in the range of sheets you want to sum.
   • Replace SheetN with the name of the last sheet in the range of sheets you want to sum.
   • Replace cell_address with the cell address containing the value you want to sum in each sheet. For example, if you want to sum cell A1 from each sheet, the formula would look like =SUM(Sheet1:SheetN!A1).
5. Press Enter to complete the formula.

Excel will now display the total sum of the specified cells across the specified sheets.

Example

Let's assume you have an Excel workbook with three sheets named "January", "February", and "March". Each sheet contains the total sales for each month in cell B2. You want to calculate the total sales for the first quarter in a summary sheet.

1. Create a new sheet named "Summary".
2. Click on cell A1 in the "Summary" sheet.
3. Enter the following formula: =SUM(January:March!B2).
4. Press Enter.

Excel will now display the total sales for the first quarter in cell A1 of the "Summary" sheet by summing the sales values in cell B2 from the "January", "February", and "March" sheets.