AVERAGEIFS Function - Excel
Overview
The AVERAGEIFS function in Excel is a useful tool for calculating the average of a range of numbers based on multiple specified conditions or criteria. This function allows you to apply multiple criteria and calculate the average of only the cells that meet all the specified conditions.
Example:
=AVERAGEIFS(C2:C11, D2:D11, "lion", E2:E11, "run")
Syntax:
=AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
average_range: The range of cells to average.
criteria_range1, criteria_range2, ...: The ranges where the criteria are applied.
criteria1, criteria2, ...: The conditions that determine which cells to include in the average for each corresponding criteria_range.
Example
In the example above, the AVERAGEIFS function will average out the numbers in range C2:C11 for those that meet the criteria in range D2:D11 and E2:E11. The criteria for range D2:D11 is that it must equal “lion” and the criteria for range E2:E11 is that it must equal “run”. The final output of the function is 3.5 because the only numbers that met the criteria were 1 and 6 and that is what they average out too.