How to changes from AVERAGEIFS to Median

[mellons1`]

I am currently using this formula to find average data with a few parameters. I need to change it to median though. Any thoughts?

=Iferror(averageifs('Data_Sheet_1'!$G$2:$G,'Data_Sheet_1'!$B$2:$B,$A$2,'Data_Sheet_1'!$E$2:$E,B$1),"No one in band")

 

[Domenic]

Try the following formula, which needs to be confirmed with CONTROL+SHIFT+ENTER, not just ENTER...

=IFERROR(MEDIAN(IF(Data_Sheet_1!$B$2:$B$100=$A$2,IF(Data_Sheet_1!$E$2:$E$100=B$1,Data_Sheet_1!$G$2:$G$100))),"No one in band")

Adjust the ranges, accordingly.

Hope this helps!