Minimum, Maximum, Mean and Median for data set with Multiple Criteria

**Stewbart13** · 08-30-2013, 02:20 PM

Hello I am trying to find the minimum value, maximum value, mean value, and median for a data set based on multiple criteria.

Manager $3,958.33 $4,123.26
Consultant $2,708.33 $3,293.73
Business Analyst $2,083.33 $2,083.33

As an example please refer to above. I would like to find the median for "Manager" and "Consultant" but not "Business Analyst". Can someone help me with the formula to do so? I would guess it starts: =MEDIAN(IF(

Thank you.

**Tony Valko** · 08-30-2013, 03:03 PM

Try this...

Data Range

	A	B	C	D	E	F	G
1	Position	Low	High		Positions		Median
2	Manager	$3,958.33	$4,123.26		Manager	Consultant	$3,626.03
3	Consultant	$2,708.33	$3,293.73
4	Business Analyst	$2,083.33	$2,083.33

This array formula** entered in G2:

=MEDIAN(IF(A2:A4=E2:F2,B2:C4))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.