When using the sum formula, if I made a change to one of the values in the
column, the total sum would automatically reflect this. Now, everytime I
make a change to the values, I have to go to the formula and hit enter for it
to update. Why is this and how do I fix it?