Good afternoon everybody,

I have a spreadsheet as follows:

Column A B C D E(net) F(VAT) G (Total) H, I, J K

1: DATE PAYEE DESCRIPTION INVOICE NUMBER(S) INCOMINGS OUTGOINGS Balance
2: 01/04/2013 Bob 12.50. 2.50. 15.00
3: 01/09/2013 B&Q Tools & Renewals 12.50. 2.50. 15.00 £5,876.56

Above is what the layout I have for accounts. I am wanting a forumula that will give me a running total. It will need to be the total of the 'K' cell above plus the amount in cell G for that row if a number is present and if not less the total of cell J. Does that make sense? I have been doing it manually for each entry but wondered if there is a conditional formulae that I could use?

I only want it to add up the totals and not the Net or VAT elements.

Thank you for your help in advance.