Is there a medianif similar to averageif

  • Thread starter Thread starter justnike4
  • Start date Start date
J

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?
 
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
 
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?
Click to expand...

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
 
Back
Top