Median of an Array
 

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

Median of an Array
 

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

--
Regards,
Tom Ogilvy


Kris Taylor wrote in message
m...
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