My formula cell has stopped adding the preceding cells.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am always using the sum formula to add up preceding cells and somehow the
formula has stopped working automatically. If I change one of the preceding
cells to a different number, the formula cell does not automatically change.
I have to go back and erase the formula and re-type it in to get the correct
number. Please advise.
 

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

Similar Threads

Comparison of columns using Conditional Formatting 3
WHAT ARE REASONS THAT A FORMULA WILL NOT RESPOND TO PRECEDENTS? 1
Clever formula required (to find the word directly preceding mychosen word) 3
How do I reference a cell to another in the preceding worksheet 8
formula to sum the prior 12 cells regardless of added columns? 6
Converting Text to Number 3
Sum and subtract columns when one cell contains preceding text 4
Inerting name of current worksheet into fuction 11

Back
Top