Minifs, maxifs, averageifs, medianifs, coeffvarifs

I need to put in some descrptive stats.
I have used SUMIFS and COUNTIFS successfully from other posts but now I need:

MINIFS, MAXIFS, AVERAGEIFS, MEDIANIFS, COEFFVARIFS

These functions don't seem to exist in Excel so what's the best way to recreate the following formula?
=COUNTIFS(EVENTS!$E$2:$E$282,">0",EVENTS!$L$2:$L$282,"<>10",EVENTS!$I$2:$I$282,"=0",EVENTS!$C$2:$C$282,"="&Descr.Stats!B6)

Crossposted. See responses in
http://www.mrexcel.com/forum/excel-questions/815170-minifs-maxifs-averageifs-medianifs-coeffvarifs.html