99.3% Of all customers recommend us, we're so confident about our results we publish all reviews and statsView Live Stats View Reviews
3d formulas in Excel 2010
The term 3D formulas is used when referring to the same cell on more than one sheet. For example, if you wanted to add together what's in cell B4 on three different sheets and display the result in a fourth sheet.
To create the 3D Formula
On the fourth sheet, type =sum(
Click on the sheet tab for the first sheet, hold down Shift and select the tab for the third sheet, then click cell B4 and press Enter.
The 3D formula created in Sheet4 would be:
The benefits of using a 3D formula in a work setting is when there are many sheets with figures to total up. For example consider the formula
This 3D formula totals up a year full of weekly sheets. It would be very time consuming or impossible to do the calculation by adding each individual sheet because of the length of formula required:
=Sheet1!B4+Sheet2!B4+Sheet3!B4 .... etc
The disadvantage of using a 3D formula is that the cells to be added all have to be the same one.
See below to see other questoins about 3D formulas.
Related forum posts:
I went on the intermediate Excel course and we discussed 3-D formulas. I am trying to do the exercises again but I am getting stuck. My main question is how to create a 3-D formula? I am using the 2003 version of Excel and I can't see the "save workspace" option. I also have read only files and am wondering whether this is restricitng me from creating the formula. I am looking forward to your feedback. Regards Adriaan
How do you create 3-D formulas to link worksheets and freeze panes.
How are errors in 3D formulas traced?
Can I use the Average function in a 3d formula? I get error messages.
How does a watch window help with 3D formulas?
how to create 3-Dformula to link worksheets
How do you link multiple spreadsheets together in a fformula?
How do I do these?
helpful hints to practice?
Welcome. Please choose your application (eg. Excel) and then post your question.
Our Microsoft Qualified trainers will then respond within 24 hours (working days).
Any suggestions, questions or comments? Please post in the Improve the forum thread.