MEDIANIFS

[Sanowar]

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

[#2]

Hello,

There is no function called MEDIANIFS. There are only SUMIFS, COUNTIFS, AVERAGEIFS, MINIFS and MAXIFS

[#3]

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

[#4]

@Sanowar 

You can get a MEDIANIFS with Power Query's grouping feature.

[#5 · Accepted solution]

@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

[#6]

@Sergei Baklan Thank you so much!

[#7]

@Sanowar , glad to help