Forum Discussion
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
- Hello,
There is no function called MEDIANIFS. There are only SUMIFS, COUNTIFS, AVERAGEIFS, MINIFS and MAXIFS - Thanks for your response. But how can I solve it, is there any VBA code or any other 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
SergeiBaklan Thank you so much!
Sanowar , glad to help
- You can also use FILTER - eg:
MEDIAN(FILTER(range, criteria1=condition1, criteria2=condition2))
etc
