The Excel AVERAGEIFS function averages cells that satisfy multiple conditions at once — for example, the average sale for the East region in Q1 that also exceeded target.
Syntax
| Argument | Description | |
|---|---|---|
average_range | Required | The cells to average — listed first, unlike AVERAGEIF. |
criteria_range1 | Required | The first range to test. |
criteria1 | Required | The condition applied to criteria_range1, e.g. "East" or ">=100". |
criteria_range2, criteria2, ... | Optional | Up to 126 more range/criteria pairs. A row must satisfy all of them. |
How to use it
AVERAGEIFS averages only the rows that meet every criteria pair you list. The big difference from AVERAGEIF: the average_range comes first, then each criteria_range, criteria pair follows.
All ranges must be the same size and shape, since AVERAGEIFS lines them up row by row. With a table where 3 rows are both "East" and "Q1" and their values total 930, =AVERAGEIFS(C2:C20,A2:A20,"East",B2:B20,"Q1") returns 310.
Argument order trap: AVERAGEIF puts the average range last (and optional); AVERAGEIFS puts it first (and required). Mixing them up is the most common AVERAGEIFS mistake.
Try it: interactive demo
Pick a AVERAGEIFS example to see the formula and its result.
Practice workbook
Frequently asked questions
How is the argument order different from AVERAGEIF?
average_range first and requires it; AVERAGEIF lists the average range last and makes it optional. This trips up many users switching between the two.How many conditions can AVERAGEIFS handle?
Do all the ranges have to be the same size?
#VALUE! error.Why does AVERAGEIFS return #DIV/0!?
Master functions like this in one day
This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class