Need help with dynamic named ranges and medians based on specific criteria

[RedDrum79]

Good afternoon everyone,
I've been lurking around for a while and have learned a good bit about excel and how to muddle through it, but I have run into a problem I cannot seem to solve.

I have attached a sample workbook with data and a brief description of what I need.

I am attempting to set up a spreadsheet where I can count matches in column B and count non matches in column B. If column B matches the criteria I need to obtain the median of column C, the median of column D and the median of column E as well as the median of Column D/Column C. I need it to be set up as dynamic named ranges as the number of rows will change frequently. I have removed the other columns from the data to make it easier to read and to remove any sensitive data. If it matters, there are typically 38 columns, but the ones included are the ones pertinent to the questions at hand. The number of rows will change frequently.

I have tried setting up the dynamic named ranges, but ran into particular problems with column B due to there being blank cells I think. So I thought I would reach out here to see if anyone has a simpler and more elegant solution to manually manipulating the data everytime I run this report.

Also, if at all possible, I need this to be functional in excel 97-2003. I have the current version, but the reports will be opened in an older version when I am done working on them.

Thank you tremendously