AVERAGEIFS function

description:

Returns the average (arithmetic mean) of its arguments specified by a given set of criteria.

 

syntax:

=SUMIFS( sum_rangecriteria_range1criteria1[criteria_range2][criteria2], … )

 

required arguments:

sum_range The range to average.
criteria_range1 The first range to evaluate.
criteria1 The criteria to use on criteria_range1.

 

optional arguments:

[criteria_range2] The second range to evaluate.
[criteria2] The criteria to use on criteria_range2.