I have my finances in an excel spreadsheet, in one column i have all my
expenses for half the month at the bottom I total the expenses. As I add and
delete an expense the total does not change. If I go directly to the cell
where the formula is in and double click on that particular cell it totals
out what I have deleted or added. what am I to do about this? I have started
a new spreadsheet because I could not figure out how this happened nor could
I fix it. Stayed up half the night trying things.. Please help!!!
Example formula =f1-sum(f4:f30) total is in cell f35

is this right or wrong?