Excel AVERAGEIFS function

Function              AVERAGEIFS

Description        Excel AVERAGEIFS function averages the value of those cells within a range which meets multiple criteria.

Syntax  AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)

average_range  The range to be average.

criteria_range1  This is the first range to evaluate.

criteria1  The criteria which to be used on criteria_range1.

criteria_range2  [optional] This is the second range to evaluate.

criteria2  [optional] The criteria which to be used on criteria_range2.

Example: