I have the following formula =IF(B5="","",E4-C5+D5) which works for a savings tracking worksheet.



I made a new worksheet because I changed banks and the formula I need is a bit different.

column "C" is withdrawal
column "D" is Deposit
Column "E" is Total

The first row I have data in is 3, I have an amount in D3 and the total which is the same in E3 as it is my first deposit.

I would like the correct formula for the following

E3 Which is "Total" as the starting cell which I have a dollar amount in now and then I want anything in column C to to subtract from Column "E" which is Total

Then anything in column D to add to column "E" which is Total
then I want to paste in E4 so that the total will calculate in all cells in column "E" all the way down that column.


I hope I explained what I need correctly but to sum it up I just need a formula that takes the total in E3 then Subtracts any amounts in column C and add any amount that is in column D and updates the total in the whole column of E

So as I add or subtract in C or D the Total will update in column E all the way down the column.



Thank you very much in advance