AVERAGEIFS Function Explained
The AVERAGEIFS Function in Microsoft Excel calculates the average of all numbers in a range that meet multiple criteria. It takes up to 127 range/criteria pairs as arguments, and returns the average of the numbers in the specified range that meet all the criteria.
AVERAGEIFS Function Syntax
AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
- average_range: The range of cells to average.
- criteria_range1: The range of cells to evaluate for the first criteria.
- criteria1: The criteria in the form of a number, expression, cell reference, or text that defines which cells will be averaged.
- criteria_range2: (optional) The range of cells to evaluate for the second criteria.
- criteria2: (optional) The criteria in the form of a number, expression, cell reference, or text that defines which cells will be averaged.