right formula?

[blaccherie]

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?

 

[blaccherie]

I will try your suggestions first and if it does not work I will send it to
you.. Thank you. I also noticed that it is attached to another worksheet so I
ungrouped these 2 worksheets.

 

[blaccherie]

ok so I checked the calculations, it was on manual changed it to auto except
for data tables. Thanks it works perfectly...