ExcelBanter - Total formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Total formula (https://www.excelbanter.com/excel-discussion-misc-queries/446757-total-formula.html)

Martin ©¿©¬[_2_]

Total formula

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
©¿©¬

Total formula

On Fri, 03 Aug 2012 12:53:42 +0100, Martin ©¿©¬
wrote:

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

All times are GMT +1. The time now is 11:48 PM.