AVERAGEIFS function
AVERAGEIFS returns the average (arithmetic mean) of all cells that meet multiple criteria.
Syntax
AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...
- average_range is the range to be averaged. It can be one or more cells including numbers or names, arrays, or references that have numbers.
- criteria_range1 is the range to be checked by the corresponding criteria.
- criteria1 is the criteria that defines which cells are averaged. The criteria can be a number, expression, cell reference, or text.
- [criteria_range2, criteria2](optional) are additional ranges and their corresponding criteria. You can enter a maximum of 127 ranges and criteria.
Example
=AVERAGEIFS(A2:A5,A2:A5,"<150",A2:A5,">60" )
Calculates the average of cells A2 through A5 that are between 60 and 150.