my sum function is not working properly

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
 
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

Back
Top