With worksheetfunctions, Array enter (using Ctrl-Shift-Enter) a formula
like:

=MEDIAN(IF($B$2:$B$200=E2,$C$2*:$C$200))

That will return the median of numbers in C2:C200 where B2:B200 matched cell
E2.

HTH,
Bernie
MS Excel MVP

"justnike4" wrote in message
...
I need to calculate the median for a day of the week over an entire year.
It
is possible to do this with averageif but is there something similar
calculating the median?