Create 3-D Formulas in Excel

In more complex worksheets, you may want to create formulas that refer to data on another worksheet. 3-D formulas allow us to do this, fairly easily.

 

The syntax for the formula is worksheet_name!reference.
"Worksheet_name" refers to the name of the worksheet that provides the information. "Reference" is the name of the cell or range that holds the information we want to use. "!" is the divider between the two parts.

---

How To Create a 3-D formula:

1. Select the cell into which you want to enter the function.
2. Click the Edit Formula button.
3. From the functions list, select the desired function.
4. Click the tab for the first worksheet you want to reference.
5. While holding the Shift key, click the tab for the last worksheet you want to reference.
6. Select the cell or range of cells you want to reference.
7. Press Enter to finish the formula.