Now why didn't I think of that. I tried using IF(AND()) and it didn't like
what I had.

"Domenic" wrote:

Try...

=MEDIAN(IF(D$2:D$107=D111,IF(F$2:Q$107<"",F$2:Q$1 07)))

Hope this helps!

In article ,
Barb Reinhardt wrote:

I have cells in F2:Q107 that are blank and the calculations appear to treat
those as zeros. What needs to be changed.