Help! Formula problem

[Rickhotblue]

I would appreciate anyone that could help me with the following problem. 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

 

[JMB]

The income between two dates (note I put the previous reconciliation date in
cell F1 as I don't know where yours is):

=SUMIF(A1:A3,">"&F1,B1:B3)-SUMIF(A1:A3,">="&C1,B1:B3)

The formula sums the amounts between the two dates. If you want to include
the date in C1 in the total then change ">=" to ">" (in the second Sumif
formula). If you wanted to include the last reconciliation date (F1), you
would change ">" to ">=" (in the first Sumif formula).

The formula is the same for the bills, but change the cell references.