3D-reference

 

A 3D-reference in Excel refers to the same cell or range on multiple worksheets. First, we’ll look at the alternative.

1. On the Company sheet, select cell B2 and type an equal sign =

Alternative, Step 1

2. Go to the North sheet, select cell B2 and type a +

Alternative, Step 2

3. Repeat step 2 for the Mid and South sheet.

Result.

Formula

4. This is quite a lot of work. Instead of doing this, use the following 3D-reference: North:South!B2 as the argument for the SUM function.

3D-reference in Excel

5. If you add worksheets between North and South, this worksheet is automatically included in the formula in cell B2.

Add Worksheet

Previous articleWorksheets in Excel
Next articleAnova in Excel