My Excel formula problem

  Forum Editor 12:53 11 Jul 2004
Locked

Regular forum members will know that Excel is definitely not one of my areas of expertise, and I need help with this:-

I have a spreadsheet in which I need column totals to update as I enter figures in other columns. I'm OK with the formula side of things, and that works perfectly, but I can't seem to sort one aspect of it. The final column shows the net total, after all the figures have been entered in the other columns and the forumla has done its calculations. When I try to apply the formula to all the cells below the last entry in that column the last total figure appears - dozens of cells, all with the same figure. It's a cosmetic thing, but I would like the cells to be blank until they need to contain figures, and no matter what I do they steadfastly refuse.

If anyone can help I would be grateful - VoG where are you when I need you?

  Forum Editor 13:34 11 Jul 2004

Many thanks for your prompt and (as ever) correct solution.

Fullywired - thanks to you also. The forumla is more cpmplex than simply adding totals - there are deductions being made in some columns as well. The data is subject to client confidentiality, so I couldn't send the file to anyone. Fortunately the problem's now resolved.

I've been promising myself an update to my limited Excel skills for some time, but I never seem to get a chance. On the other hand......why bother when I have access to such expertise?

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Google Pixel 3 review

Automatically create thousands of unique variations from one original design with this Illustrator…

iPhone XR release date, price & specs

Test : le Razer Phone 2