Excel 3D Reference - easily reference data on another worksheet

A 3D reference in Excel is a simple method to pull data from another cell, another worksheet, or a range of worksheets. Changes in the source will reflect in the destination.

Excel 3D reference

You can use multiple functions when creating a 3D reference. Functions such as Sum, Average, Count, Counta, Max, and Min all work with a 3D reference.

Examples of 3D references

1. In cell R2 we can use a 3D reference for =B2. Changes in B2 will reflect in cell R2l. 2. =Monday!B2 reference the Monday worksheet. Changes in cell B2 on the Monday worksheet will update when the source updates. 3. =Sum(East:West!B2) changes in the worksheets that start with East and go to West for cell B2 will reflect. We could have multiple worksheets between the East and West worksheets.

YouTube Video

Excel 3D Reference - easily reference data on another worksheet

Video of 3D references using multiple worksheets

Excel how to use a 3D reference to add worksheets by Chris Menard - YouTube