Forum Discussion
Solved
MEDIANIFS
I want to use MEDIAN with multiple conditions, but not found MEDIANIFS function like AVERAGEIFS function. Is there any way?
You may use MEDIAN with nested IF() on the range taking into account all FALSE will be ignored. Please check https://exceljet.net/formula/conditional-median-with-criteria
You can also use FILTER - eg:
MEDIAN(FILTER(range, criteria1=condition1, criteria2=condition2))
etc
MEDIAN(FILTER(range, criteria1=condition1, criteria2=condition2))
etc