3D formula

Resolved · Low Priority · Version Standard

Tue 18 Mar 2008, 16:35 Delegate Daissy said...

Daissy has attended:
Excel Intermediate course
PowerPoint Introduction course

3D formula

what is the easiet way to create a 3D formula

Sun 30 Mar 2008, 20:03 Trainer Mara said...

RE: 3D formula

Hello Daissy,
I hope you enjoyed your training sessions with us.

I have found another posting in our forum that discusses 3D formulas:
https://www.stl-training.co.uk/post-4823-freeze-panesd-formulas.html

If you have more specific questions on using 3D formulas, please feel free to reply to this posting and I would be more than happy to help you further. Otherwise, if it has resolved your question, please mark this question as resolved.

Have a great day.

Regards,
Mara
Microsoft Office Specialist Master Trainer

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Sum Up All the Values in A Column

If you want to quickly calculate the Summed values of all cells in a column in Excel 2003 normally you would use the SUM formula. (eg if you wanted to calculate the values in Column C rows 10 to 25) the formula would be:

=SUM(C10:C25)

However, if you keep adding values to column C you would keep having to modify the above SUM formula which can get quite annoying.

To get around this you can sum all the values in a column using the following formula:

=SUM(COLUMN:COLUMN)

Which, in our example, would be:

=SUM(C:C)

NOTE You cannot place this formula in column C, or else Excel 2003 will show a circular reference error.

The formula must be placed in any other column, EXCEPT the one being calculated.