Excel - Total formula

Asked By Martin ©¿©¬ on 03-Aug-12 07:53 AM
Hi
I have a small spreadsheet for income which I input relating to date
using
=IF($A3<=TODAY(),166.24,"")
&
=IF($A4<=TODAY(),500,"")

I then manually insert withdrawals & calculate the balance.
How would I create a formula that calculates the balance by date?

A		    C  		    E		        G I
Date		   In		   In		Withdrawn Balance
?30.11
01/03/2012			166.24 ?196.35
07/03/2012	500.00 ?696.35

--
Martin
????


Martin ©¿©¬ replied to Martin ©¿©¬ on 03-Aug-12 09:27 AM