MEDIAN with multiple conditions

Hi again,

Just a quick question, i have this data that i need to formulate.

What I need is MEDIAN but with multiple criteria.

I want excel to formulate this scenario:

Median should only accept the following conditions:

Grade Column should only be "BA1"
Salary Column should not include "0"
Gender Column should only include "Male"

anyone can help me with this? Thanks in advance!

You need to use an array formula along the lines of:

=MEDIAN(IF(conditions,array))

but you need to tell us where your data is, i.e. which columns are used for Grade, Salary and Gender. and how many rows of data do you have. I presume it is the Salary column that you want the conditional MEDIAN of ?

Hope this helps.

Pete

Hi Pete,

Thanks for this, will try it.

Yes I want to get the median of the salary column

Grade = Column E
Salary = Column W
Gender = Column C

Hi Pete I think your suggestion works!

=MEDIAN(IF('Tab 1 - Master'!C:C="Male",IF('Tab 1 - Master'!E:E="BA1",IF('Tab 1 - Master'!W:W<>0,'Tab 1 - Master'!W:W))))

will try to check it manually thanks a lot!