Median of an Array

[Kris Taylor]

I have been trying to calculate the median of a set of data with two
stipulations. The first being that the cell in column T must be equal
to 0.1. The 2nd stipulation is that the cell in column M must be
greater that 0 but smaller than 100. If both of those statements can
be deemed true, I want to calculate the median of those rows in column
M. This database contains 91 entries.

The current formula that I have looks like this:

{=MEDIAN(IF(AND(T9:T100=0.1, M9:M100<100),M9:M100,""))}

I am currently getting a #value error.

Please help me!!

Any feedback would be greatly appreciated.

Thanks in advance,

Kris Taylor

 

[Tom Ogilvy]

{=MEDIAN(IF((T9:T100=0.1)*( M9:M100<100),M9:M100))}