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

Check if a date comes before/after a range of dates 0
Sum of Numbers of a Rolling 6 month Period range 0
Assistance need to populate "GRAND TOTAl" "MSpivottable11" in Microsoft web component 0
How do I count the number of blank cells 0
Allocate an income payment over a date range (tax years) 7
Help on multiple criteria for formula and return a date 1
Sumproduct or Sumif formula 5
Formula to fill cells based on Date of Arrival and Date of Departure 1

Top