I have created a home finances worksheet which list income in and income out
by dates. I need to create a formula that will sum a range of cells based on
whether that income coming in or out is on a certain date,which is in a cell
ajacent to that cell. I need the formula Here is the basic outline.
Basically I want to be able to compare money coming in and money going out in
any certain week and see if on a set date (always on Friday) if we have
enough money
I would really appreciate if someone would help me with this. Thank you

A B C
D E
INCOME Date Amount Paid Date
Oneica's Pay 2/9/2007 65.00 2/9\07
Oneica's Pay Advant 2/16/2007 100.00
Oneica's Pay 2/16/2007 65.00
Oneica's Pay Advant 2/23/2007 140.00
Oneica's Pay 2/23/2007 440.00
Oneica's Pay Advant 3/2/2007
Oneica's Pay 3/2/2007 330.00
Oneica's PayAdvant 3/9/2007
Oneica's Pay 3/9/2007 330.00
Rick's Pay 3/9/2007
Rick's Pay 2/7/2007 400.00 2/7/2007
Rick's Pay 2/21/2007 300.00
Misc income 2/8/2007
Misc income 2/8/2007
Total 1,705.00
Master Card 2/15/2007 1.19
Cash 2/15/2007 25.00
Total 26.19
BILLS Paid Date
Car 2/9/2007 120.00 2/8/2007
Car 2/23/2007 -120.00
Phone 2/28/2007 -160.00
Electric 3/5/2007 225.00 2/7/2007
Electric 3/5/2007 -165.00
Insurance 3/4/2007 41.00 2/4/2007
House Payment 2/7/2007 472.30 2/8/2007
House Payment 3/7/2007 -472.3
Water 2/16/2007 -50.00
Comcast 4/1/2007
ATT 2/26/2007 -41.54
Gym 2/28/2007 -41.00
Total -1,049.84









Date Figured 3/9/2007
Amount 681.35