excel sum function

[George]

I have a sum function at the lower end of a column that
will add all numbers found in that column. When I reopened
the worsheet next day and typed in more numbers in that
same column, in empty cells, the sum functions does not
add the new values. If I click on the cell that contains
the formula it shows that the formula is still there and
looks at all the cells above in that column. If I type in
a new value and then re-enter the formula it will
calculate correctly including the new value. I don`t know
if this a software problem or I am doing something wrong.
I think that once you set up a formula and you save that
worksheet (which I did) you should be able to retrieve it,
add new values in the empty cells of that column and the
formula should calculate the sum seing the new added
values, but it does not see the new values.
Did anybody have this problem?
Please help.
Thank you,
George

 

[Guest]

Have you checked your 'Calc' settings? It sounds like the
worksheet is set to Manual Calculation.
Check 'Tools --> Options --> Calculation' and make sure
the Automatic radio button is selected.

Allan

 

[Beth]

George,
Make sure you have automatic calculation selected. Go to
Tools, Options, Calculation tab. Select the Automatic
Calculation radio button.