Creating Daily Balances

[jeck876]

I have 4 columns of data. I need a formula to calculate daily balances.
there are always three consecutive months of data, but the months may change.
there is month, amount, description (which i have XXX'ed out) and if it is a addition or subtraction to the account.

I need a formula that will go through each day and add any additions and subtract and subtractions, then give me the balance for that day and then continue and calculate the following days. I have attached a example workbook showing my raw data.

THANKS!!!!

[JohnTopley]

in F1 and across I have dates 01/06/2015 , 02/06/2015 ....

if F2 and drag across

=SUMIFS($B$1:$B$400,$A$1:$A$400,F$1,$D$1:$D$400,"Addition")+SUMIFS($B$1:$B$400,$A$1:$A$400,F$1,$D$1:$D$400,"Subtraction")