Running total error

[Eyon]

Hi, First post here and I'm not a very good user of excel.

Basically, I have put all my bank accounts into a big excel spreadsheet so I can track payments in and out through all my accounts and categorise my spending to see what I spend too much on! Boring, huh?

I decided the other day to add a running total into the sheet.

The first cell uses this formula:

=D7+SUM(D13-E13)

D7 is my initial account balance. D13 is money in, E13 is money out.

The successive cell uses:

=SUM(F13,D14-E14)

Again, column D is money in, E is money out, and F is my running total column.

This works perfectly for me, starting at row 13 all the way down to row 272. After this, not changing the formula (by this time it is =SUM(F272,D273-E273)), on row 273, I get #VALUE!

The formula hasn't changed, the balance isnt big enough to not fit in the cell (unfortunately)...it just stops working? The formula seems right, and even if I type it in manually (instead of dragging the formula down) it still gives the error?

Any idea?

Thanks
Ian

 

[Titian]

Check the figures you have keyed in on rows 272 & 273 (maybe re-enter them).

 

[Eyon]

Just tried, still no luck, just get #value.

I'm working with basic numbers including double negatives, but my spreadsheet is full of them before this row so I know the formula works

 

[Peter_SSs]

Presumably either D273 or E273 appears blank. Select that 'blank' cell (or both cells if they both appear blank) and press the Delete key. Does the formula on row 273 now show a number instead of #VALUE!?

 

[Eyon]

Thanks for the reply. Sadly However, it does not work.

You are correct though, one column is always empty, the other with a value.

I have made sure both are empty, still get #VALUE"!

I then changed the formula to =SUM(F272,D272-E273) and believe it or not, the #VALUE! goes away, even though my sums are totally wrong.

So it seems that D273 is faulty cell

Literally as I was typing this I thought id see what was wrong with the cell, so I right clicked, cleared contents (even though it was empty?!) and bingo! It works!

Weird!

Thanks for the help, job done