I added how I do my deposits and withdrawals in the image above and it shows how the balance in the "Total" column "E" updates. This is what I am trying to do.


What I can't understand is I have the identical worksheet set up the exact same way as the one above with one exception, the formula is entered in E5, the formula is =IF(B5="","",E4-C5+D5)

That worksheet has one more row in the top of the sheet that is why the formula in in E5 in the one above I need the formula to be in E4 but the rest should work.
The worksheet that has this formula =IF(B5="","",E4-C5+D5) works perfectly. I enter a withdrawal in column C row 4 then the total changes to reflect the withdrawal. I enter a deposit in column D and it adds to the total

I do not enter a withdrawal and a deposit on the same row , the deposits are entered in column D then withdrawals are in column C but in the next row down there is never a deposit and withdrawal in the same row.

why doesn't it work???