When using a 3-D reference in a formula,first select the tabs for the source worksheets,then begin typing the formula.

Question

Quizplus · Accepted Answer

When using a 3-D reference in a formula, you first need to select the cell where you want to display the formula, then type the formula and use the syntax: reference to the range of cells in each sheet separated by commas, enclosed in parentheses. For example, "=SUM(Sheet1:Sheet3!A1)" would add up the values in cell A1 on Sheet1, Sheet2, and Sheet3.

When Using a 3-D Reference in a Formula,first Select the Tabs