Forum Discussion

Copper Contributor

Mar 23, 2020

Solved

MEDIANIFS

I want to use MEDIAN with multiple conditions, but not found MEDIANIFS function like AVERAGEIFS function. Is there any way?

SergeiBaklan
Mar 23, 2020
Sanowar

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

Copper Contributor

Mar 23, 2020

Thanks for your response. But how can I solve it, is there any VBA code or any other way?

Detlef_Lewin
Silver Contributor
Mar 23, 2020
Sanowar
You can get a MEDIANIFS with Power Query's grouping feature.

Resources