Help querying a date range and returning a value

[druth]

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!

[GeneralDisarray]

looks like a textbook pivot table application, but can you post an example of an actual worksheet to show you on?

[druth]

Here is my data set that I am querying. I am hoping to code the first table that I have attached with the formulas.

Sheet1.pdf

Thanks!

[GeneralDisarray]

Sorry, by "worksheet" I meant excel file. Can you upload a spreadsheet to work with?

[druth]

Help.xlsx

Here ya go...

[druth]

Have you had a chance to take a look yet?