Count Occurrences Date Range Falls Within Month

[Rbooth]

MLS Pending Sales.xlsx

Hello,

I have spent hours trying to figure this out on my own and have poured through online threads to find the answer, but have not succeeded. I am working on a Real Estate Market Report and am trying to track the homes that were "Pending" during previous months. Unfortunately, my local MLS does not track this data directly. There is no way to look back at January 2006 to see how many homes were "Pending" in that month. However, they do provide the date the home went into pending status as well as a closing date: providing the entire period the home was Pending. I have attached a workbook with three sheets; two for each year, and one for the report. In the Year sheets Column A holds the Pending Date and in B Closing Date. On the report sheet I have listed each month from A3:A14, and "2006" in B2 and "2007" in C2. I want to count how many homes were in a pending status for each month. I have tried using countifs as well as sumproduct, but can't seem to find the answer. Any help would be greatly appreciated.