Please post a small sample sheet

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hi
Why is E3+C4+D4 not a formula?
E3 is your opening balance.
C4 is your first withdrawal - if any.
D4 is your first deposit - if any.
You seem to be hung up on your original formula. It does not work for you - forget it.
I have provided you with a solution AND A FORMULA - why do you not want to use it?
Tony

I'm sorry you don't think I am not taking your advice. a formula looks like this
=IF(B5="","",E4-C5+D5)

What formula that I can paste into a cell and drag it down will give me a running total?
I do not see your formula doesn't a formula start with a "=" sign??

Don't be insulted you are not giving me what I need. sorry

This is also a formula

=IF(DATEDIF(A9,B9,"y")=0,"",DATEDIF(A9,B9,"y ")&" years ")&IF(DATEDIF(A9,B9,"ym")=0,"",DATEDIF(A9,B9,"ym") &" months ")&DATEDIF(A9,B9,"md")&" days"

Hi
Then just add an = sign before my formula!
And then drag it down the column to repeat it.
Just for information the = sign is not part of the formula it simply indicates to Excel that everything after the = sign is a formula.
Good luck.
Tony

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???