How to use 3D Formulas - Great for tracking multiple tabs! #howto

#howto How to use 3D formulas are a great way in Microsoft Excel to reference multiple sheets in a workbook or several spreadsheets, it's only getting more powerful in Office 365 in what you can draw from. You can instead of using a function on a range in a single sheet, you can expand that to multiple sheets with either a static or dynamic range, this is a simple example but illustrates the point fairly well of how to start using these powerful functions.

[ExcelDude]

3D formulas are great for working with multiple sheets, I think of them as bookends on different sheets, you can select a range within a range, so sort of like worksheet-ception? If anyone has experience with these I'd love to hear your uses and perspectives on these neat functions!