Try the following formulas, which needs to be confirmed with
CONTROL+SHIFT+ENTER...

=MEDIAN(IF(D2:D107=D111,F2:Q107))

and

=STDEV(IF(D2:D107=D111,F2:Q107))

Hope this helps!

In article ,
Barb Reinhardt wrote:

I want to get the MEDIAN of the values in F2:Q107 only if the value in
D2:D107 = D111, how do I do this. I want to do the same thing with MEDIAN.
I don't want to use a pivot table if I can avoid it.

Thanks in advance,
Barb Reinhardt