Conditional Median

Posted by John Munoz on January 18, 2002 11:10 AM

I'm trying to calculate the median of salaries with a particular job code within a large set of data...something like a Sumif function but to calculate the median. Is there a way to do this?

Posted by Juan Pablo G. on January 18, 2002 11:22 AM

{=MEDIAN(IF(A1:A100="JobCode",B1:B100))}

This is an Array formula. To enter it press Ctrl Shift Enter

Juan Pablo G.

Posted by John Munoz on January 18, 2002 11:42 AM

Thanks Juan!