3D Formulas are a great way to create summary calculations based on data that spans multiple sheets.
Imagine having 12 sheets, January thru December, with sales for each month. In cell A1 of each sheet is the total of all sales for the respective month. Our objective is to add all the totals for the 12 months to get a yearly total.
What makes 3D Formulas so useful is that instead of referencing the same cell location for every sheet, in this case, it would be 12 references, we can reference the one cell while reducing the sheet references to a [StartSheet….FinishSheet] structure.
We can add sheets to the workbook and have them automatically incorporate into the established calculation (provided certain requirements are met.)
For an in-depth guide to creating 3D Formulas, click here to read the full post.