AVERAGEIF
Syntax
=AVERAGEIF(range; criteria; [average_range])
Description
Calculates the average of cells that meet a given criteria.