Short Answer 
The answer explains how to create 3D references in Excel to sum cells across multiple sheets. For consecutive sheets, you can use a simple formula like =SUM(Sheet1:Sheet3!C4), while for non-consecutive sheets, you need to reference each sheet individually, such as =Sheet1!C4 + Sheet2!C4 + Sheet3!C4.
Step 1: Understand 3D References
In Excel, a 3D reference allows you to reference the same cell across multiple sheets in a workbook. This is particularly useful when you need to sum data from a range of sheets without creating separate formulas for each sheet. To create a 3D reference, use the following syntax: =SUM(Sheet1:Sheet3!C4), where “Sheet1” is the first sheet and “Sheet3” is the last sheet of your range.
Step 2: Summing Across Consecutive Sheets
When the sheets are consecutive, you can effortlessly sum the same cell from each sheet. If all desired sheets contain data in the same cell, like C4, you can apply a simple formula to get the total. Ensure that the structure is uniform across those sheets. Just make sure to revise your range accordingly depending on your specific sheets.
Step 3: Handling Non-Consecutive Sheets
If your sheets are non-consecutive, you won’t be able to use the 3D reference method directly. Instead, you’ll need to sum the cell values individually by explicitly referencing each sheet. For example, use the formula: =Sheet1!C4 + Sheet2!C4 + Sheet3!C4. Repeat this for all sheets you wish to include in your sum, ensuring each is accurately referenced.