right formula?
 

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?

right formula?
 

Apparently it is happening with ony a particular worksheet, right?

Does it recalculate if you hit F9.

Do check your Auto Calcuate setting.. Tools-Options-Caluclation (I think)
Excel version?

If the problem persists then can you upload to wikisend or send the file to
me?

"blaccherie" wrote:

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?

right formula?
 

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.

"Sheeloo" wrote:

Apparently it is happening with ony a particular worksheet, right?

Does it recalculate if you hit F9.

Do check your Auto Calcuate setting.. Tools-Options-Caluclation (I think)
Excel version?

If the problem persists then can you upload to wikisend or send the file to
me?

"blaccherie" wrote:

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?

right formula?
 

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

"Sheeloo" wrote:

Apparently it is happening with ony a particular worksheet, right?

Does it recalculate if you hit F9.

Do check your Auto Calcuate setting.. Tools-Options-Caluclation (I think)
Excel version?

If the problem persists then can you upload to wikisend or send the file to
me?

"blaccherie" wrote:

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?