Hi,

I have a list of Dates in Column A and a list of Rents amounts in Column B.
I'm trying to create a formula that will provide a rent for a specific month.
Here's an example:

Date Rent
5/1/2003 1400
5/1/2007 1800
5/1/2009 2150


i need a formula which will pull the monthly rent amount from 6/1/2006 thru
9/1/2009. I've tried a few arrays and sumproducts, but my formula's will only
see if the 5/1/2003 is greater than 6/1/2006 and since it's not i get an
error or it will only pull the $1400. Any help would be greatly appreciated.


Thanks!

Dave