Excel AVERAGEIF function
Function AVERAGEIF
Description Excel AVERAGEIF function average cell values specified by a given condition or criteria.
Syntax AVERAGEIF(range, criteria, [average_range])
range is the range of the array from where the criteria will be matched
Criteria the criteria which needs to match.
[average_range] is the range from where the numbers will be average which meets the criteria.
Example: