Excel 2007 MedianIfs()

I want to calculate some statistics.

In order to calculate the average of certain values of a column, I use AverageIfs().

Now I want to calculate the median for the same values. But there is no MedianIfs() function.

Is t开发者_运维知识库here a simple solution to calculate the median for values that hold certain conditions (2 conditions)?

Have a look at this response on an Excel board