Is there a medianif similar to averageif

[justnike4]

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?

 

[Martin Fishlock]

Hi:

There isn't a median if, to the best of my knowledge.

But have a look here
http://www.bettersolutions.com/excel/EIK284/LN622911811.htm
where Russell Proctor has written a very nice user defined function.

 

[Bernie Deitrick]

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

 

[Ron Rosenfeld]

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?

No MEDIANIF. However, you could use an array formula similar to this,
depending on your precise specifications:

=MEDIAN(IF(WEEKDAY(B1:B365)=2,A1:A365))

After you make the appropriate changes in the references, enter the formula by
holding down <ctrl><shift> while you hit <enter>. Excel will place braces
{...} around the formula.
--ron