What is the limitation of 3D sum? Which advanced spreadsheet option can be used
to overcome the problem & how?
Answers
Answered by
2
Answer:
the first worksheet that you want to reference. Hold down SHIFT and click the tab for the last worksheet that you want to reference. Select the cell or range of cells that you want to reference. Complete the formula, and then press ENTER.
Answered by
0
Answer:
Explanation:
How to create a 3-D reference in Excel
Click the cell where you want to enter your 3D formula.
Type the equal sign (=), enter the function's name, and type an opening parenthesis, e.g. =SUM(
Click the tab of the first worksheet that you want to include in a 3D reference.
Similar questions