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!