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
Hello,
There is no function called MEDIANIFS. There are only SUMIFS, COUNTIFS, AVERAGEIFS, MINIFS and MAXIFS
There is no function called MEDIANIFS. There are only SUMIFS, COUNTIFS, AVERAGEIFS, MINIFS and MAXIFS