In article ,
Barb Reinhardt wrote:

This does what I want, thanks.

You're welcome! Glad I could help!

How do I copy it over a bunch of cells?

If you're copying the formula down the column...

=MEDIAN(IF(D$2:D$107=D111,F$2:Q$107))

If you're copying the formula across the row...

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

DO I have to confirm each and every one?

No, you only need to confirm with CONTROL+SHIFT+ENTER for the first
cell, then you can copy or drag the formula down or across...

Hope this helps!