AVERAGEIF(range,criteria,actual_range)
range: cell area
criteria: condition for a cell to be included
actual_range: cell area, defaults to range
This function is Excel compatible.
SUMIF, COUNTIF.