Help with Excel formula

i use this balance sheet for deposits and expenses.

heres the formula I use

=IF(AND(D3<>"",D4=""),SUM($D$3:E3),"")

D3 = revenue entries
D4 = expense (-ve)

i then copy the formula all the way down the sheet.

whenever I piut an expense in I also put zero in revenue.

Revenue..........Expense ...............running total
£30.00
£10.00
£25.00
£0.00 .............-£89.78
£40.00
£40.00.....................................£990.46


the ....... where to try and keep columns in the html post


the formula goes down the running total column

happy to send a copy of spreadsheet if required

 

sent sample spreadsheet

 

you have to put a negative number in for expenses so revenue 0 expense -50.00

or if you modify the fomula and copy down.
so instead of =IF(AND(D3<>"",D4=""),SUM($D$3:E3),"")
change to =IF(AND(D3<>"",D4=""),(SUM($D$33)-sum($E$3:E3)),"")

then it will add everything in col D and subtract Col E

I have sent a new version
=IF(AND(D3<>"",D4=""),SUM($D$33)-SUM($E$3:E3),"")

so a : and next to a D = face so again
=IF(AND(D3<>"",D4=""),SUM($D$3 : D3)-SUM($E$3 : E3),"")
ignore the spaces in brackets this was to avoid the face

 

OK re reading you request I have modified the formaula my original spreadsheet required the data to be entered sequentially, so I have added a test value to see if any entry has been entered on any row and then put the subtotal against that row.

=IF(G3=0,"",IF(AND(D3<>"",D4=""),SUM($D$3: D3)-SUM($E$3:E3),""))

again fixed for faces

and in column G I have
=IF(OR(D3<>"",E3<>""),1,0)

however if column D does not have an entry then the subtotal remains in the row above , i think about this.

worked out how to attach the file so attached here

 

OK so having looked at your sample and re-read the question I have attached another sample using your template.

this will test to see if there is a balance in any cells column B or an amountpaid in Column F and which ever is the highest row number it will display a balance calculated on the totals in column B (which i dont think you want this but...) and subtract the total from column F amount paid....

see test formula1.xls

so if all you want is a running balance in rowF whever its entered and then displayed at the lowest point then -
see test formula2.xls

otherwise I really do not understand the requirements