How do update formula when change a number in another cell

[Duma]

Version: Excel 2003

If I have a column of numbers how do I change the total automatically if I
enter a different number into one of the cells in the column?

 

[Bernard Liengme]

=SUM(A:A) provided there is nothing else in column A

 

[Gord Dibben]

=SUM(range)

Make sure calculation is set to Automatic under Tools>Options>Calculation.


Gord Dibben MS Excel MVP