| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do update formula when change a number in another cell
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? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do update formula when change a number in another cell
=SUM(A:A) provided there is nothing else in column A
-- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Duma" wrote in message ... 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? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do update formula when change a number in another cell
=SUM(range)
Make sure calculation is set to Automatic under ToolsOptionsCalculation. Gord Dibben MS Excel MVP On Thu, 27 Mar 2008 03:28:03 -0700, Duma wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update Date Cell when any of target cells change | Excel Worksheet Functions | |||
| Update a date cell when a target cell change.... | Excel Discussion (Misc queries) | |||
| How to update cell on change | Excel Discussion (Misc queries) | |||
| My formula doesn't update totals when I change numbers. | Excel Discussion (Misc queries) | |||
| How do I change a number in a cell without effecting the formula? | Excel Discussion (Misc queries) | |||
Hybrid Mode
