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: