I am trying to set up a query to search a date range within a table in one sheet based upon a more narrow date range in a second sheet AND return a simple count, median currency value or value based upon a ratio (see attachment).

Note: the Sale Price, List Price and Supply values will be based upon the filtered date range (each quarter) and return a value based upon that range. The Sale Price and List Price also need to be a median within each quarter value so I can chart the data.

Help.pdf

Here is what I need to return:

Num Sales - simple count from each quarter

Num Listings - simple count from each quarter

Sales Price - median value within each queried date range

List Price - median value within each queried date range

Supply - numeric value based upon absorption rate, supply = listings each quarter / absorption rate (absorption rate = sales each quarter / months each quarter)


Thanks in advance!