Code:
=SUMIFS(ValuesColumn, CriteriaColumn, CriteriaValue)/COUNTIFS(CriteriaColumn, CriteriaValue)
In case you have several criteria columns, you add additional ",CriteriaColumn, CriteriaValue" pairs into both SUMIFS() and COUNTIFS() part of formula.