Ok...now i've done that, I have another query.

I've had to add a 4th column (F) which is a running balance. The starting balance is a minus figure (-12).

Which formula can I use which will alter the balance per day, depending on whether there is a credit in the 2nd column (D) or a debit in the 3rd (E)

Hope this makes sense.

Thanks again

Could you post an example of your sheet so far?

Here's a copy of my sheet so far

Thanks :)