Date Range evaluation and adding help

Hello,

I am ok with excel and basic queries and need some help with something more complicated.

I have a page that looks like this

Date Due Paid
9/1/2011 $385.00
10/1/2011 $385.00
11/1/2011 $385.00
12/1/2011 $385.00
1/1/2012 $385.00
2/1/2012 $385.00
3/1/2012 $385.00

On another page I have something that looks like this:

9/22/2011 $400.00
9/18/2011 $400.00
10/2/2011 $350.00
10/15/2011 $350.00

At any given time someone can make 4 payments on different days which go towards that months total.

I need to take the Date (9/1/2011) find the end of the month which I beleive is =DATE(YEAR(A7),1+MONTH(A7),0) and total
and values on the other page that fall into that Range. I messed around with SumProduct and Vlookup but didn't get anywhere.

Any help would be appreciated.

Thank you,
Brandon

If the month start is in A2, then the next month start is always the next cell down, yes? So you can refer to that next row for your cutoff date (method 1), or you can use EOMONTH() function, if you turn on the Analysis Toolpak addin (method 2).

Method 1) In B2:
=SUMPRODUCT(--(Sheet2!$A$1:$A$100>=$A2), --(Sheet2!$A$1:$A$100<$B2, Sheet2!$B$1:$B$100)

Method 2) In B2:
=SUMPRODUCT(--(Sheet2!$A$1:$A$100>=$A2), --(Sheet2!$A$1:$A$100<=EOMONTH($A2,0), Sheet2!$B$1:$B$100)

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.