Total formula

  • Thread starter Martin ©¿©¬
  • Start date
M

Martin ©¿©¬

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
 
M

Martin ©¿©¬

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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel =SUM(A1=A1+B1) 0
Find then highlight in yellow 6
Allocate an income payment over a date range (tax years) 7
Complex IF 5
Summing like data 5
Lookup between dates 1
Name The Day Of The Date2 5
Cumulative Total 9

Top