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
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
