Keeping track of payments

try in g3
=IF(E3="","",E3-SUMPRODUCT(--($A$3:$A3=A3),--($B$3:$B3=B3),($F$3:$F3)))

that has sorted it thanks!

it gives me a value error in the first cell if i dont enter a payment, it is not a problem but is there a way to get rid of this just for tidyness?


my edit button has vanished from the first post so i cant mark it as solved?