Another suggestion (but not quite as short as Tom's) - you could use this in
your formula in D2 and copy down. It should pull out the last number.

Lookup(max($D$1:$d1)+1,$d$1:$d1)


"jonco" wrote:

I have a spreadsheet with data in colum A:D rows 5:24
Lets say they're items in a list. sometimes the list has more itmes than
others.
Description Cash IN Cash Out Running Balance

If there is nothing in either the Cash In or Cash Out cells then therre will
be no running balance. for thaqt line. The last balance figure is the
running balance.

In row 25 I have different data that is sometimes there buy not always (But
it's always in row 25). Let's call that Overhead

I want to be able to get the earlier running balance figure (from somwherw
above) and Add the Cash In Figure (B25) or subtract the Cash Out figure
(C25) (if any) and update the Running Balance figure accordingly.

I use this formula to post the running balance figure if there is a plus or
minus:
=IF((B7="")*AND(C7=""),"",D6+B7-C7) -- (Example shows row 7) It displays
as blank if there is no changes to the balance figure above.

If I copy the same formula to row 25...I get a #VALUE! error when I put data
in row 25.

So, how do I get the last available figure in the column and do a
calculation on it in row 25?

Thanks for any suggestions.

Jon