How do update formula when change a number in another cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Duma - 27 Mar 2008 11:28 GMT

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?

Reply to this Message

Bernard Liengme - 27 Mar 2008 11:56 GMT

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

Signature

Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

> 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?

Reply to this Message

Gord Dibben - 27 Mar 2008 23:37 GMT

=SUM(range)

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

Gord Dibben MS Excel MVP

>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?

Reply to this Message

Rate this thread: