Formulas are right, does not total at the end.

[Guest]

Hi,

So I have a worksheet that I've worked with for months with no problem. All
of the sudden it is now neccesary to highlight the formula cell and press
enter for it to work the formula and come up with the right #.

I've never seen this before...hopfully somone out there has and knows how to
fix it.

Thanks

 

[T. Valko]

Make sure calculation is set to automatic.

Tools>Options>Calculation tab>Automatic