Bit unclear, but her is a shot

=IF(I2="Yes",K2-SUM(C3:F3),"")



HTH



RP
(remove nothere from the email address if mailing direct)


"chieron" wrote in message
...
I need to keep a bank balance with a current balance (column H) and a
running
balance (column K) for those posted on bank statement. If posted, cell
(column I) is 'yes' if not 'no'.