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

Hello I would be happy to help you with you problem but 1st if you can
shortin you ex. for me so i can work it out that would be helpful. But if you
try to use the (=SUMIF()) i think that would be your answer. but if not
please post a shorter listing of your finances ex 2 or 3 of your income in
with dates and 2 or 3 with income out.

"Rickhotblue" wrote:

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

Thank you for answering Manuel53
I hope this is short enough yet gives you the information to solve the
problem.
The weekly reconciliation formula in column D should return a result that
takes the date in (for examle) C1, compares it to the dates in column A for
Income and sums the amounts in column B if the date is between the previous
reconciliation and the date in C1. The formula than should do the same for
Bills in with the difference of the two being the result returned in column D.

Income Weekly Reconciliation
(A) (B) (C) (D)
(1) 2/18/07 420.00 2/23/07 (Formula)
(2) 2/25/07 324.00 3/2/07 (Formula)
(3) 2/28/07 237.00
Bills
(4) 2/14/07 278.00
(5) 2/16/07 158.00
(6) 2/19/07 279.00
(7) 3/1/07 100.00

"Manuel53" wrote:

Hello I would be happy to help you with you problem but 1st if you can
shortin you ex. for me so i can work it out that would be helpful. But if you
try to use the (=SUMIF()) i think that would be your answer. but if not
please post a shorter listing of your finances ex 2 or 3 of your income in
with dates and 2 or 3 with income out.

"Rickhotblue" wrote:

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