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.