AVERAGEIFS
Category: Statistical Function.
Description: Finds entries in one or more arrays that satisfy the respective criteria supplied, and returns the average (arithmetic mean) of the corresponding values in an array supplied as the first argument.
Syntax: AVERAGEIFS( average_range, criteria_range1, criteria1, [criteria_range2, criteria2], etc.)
The 'average_range' is the range for calculation.
criteria_range1, [criteria_range2], etc., are the arrays to be tested against the criteria supplied.
criteria1, [criteria2], etc., are the respective conditions to be tested.