my sum function is not working properly

G

Guest

I am trying to genrate a sheet in which one column is to be summed up at the
end.
I am using the formula =SUM(......) .After it if I change the values in the
cells covered in the formula there is no change in the total sum.
 
B

Bernard Liengme

Press F9 to recalculate
If that worked then you need to reset on option
Tools | Options; Open Calculate tab; click the Automatic button in the
Calculation group
best wishes
 
S

Stephen

rajnish said:
I am trying to genrate a sheet in which one column is to be summed up at
the
end.
I am using the formula =SUM(......) .After it if I change the values in
the
cells covered in the formula there is no change in the total sum.

Do you have calculation set to automatic or manual?
Tools > Options > Calculation tab
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top