How To Use AVERAGEIFS Function

Summary

The Excel AVERAGEIFS function is use to calculate the average of all numbers in a range of cells, based on multiple criteria range.

Purpose

Calculate the average of the selected cells based on the multiple criteria

Syntax

=AVERAGEIFS (average_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)

Example Explanation

In the above mentioned example we have calculated the average of sales values where it is greater than $100 by using multiple criteria. Formula used in G7 is:

Arguments

Average_Range – To average one or more cells, including numbers, arrays, or references containing numbers.
Criteria_Range1 – [Required] – To evaluate of the first range
Criteria1 – [Required] – The parameters that determine which cells are combined are in the form of a number, expression, cell relation or text. For our example criteria was sales values > $100.
Criteria_Range2 [Optional] – The actual range of average of cells. Scope is used when omitted.
scroll to top