Excel AVERAGEIFS Function

AVERAGEIFS averages values only when multiple conditions are all satisfied.

Use it for multi-condition averages, such as average revenue by region and month, average score by team and status, or average days for one category inside a date range.

Choose values to average The average range supplies the numbers

Add criteria pairs Each pair tests matching cells

Average matching values Every condition must pass

AVERAGEIFS syntax & arguments

Syntax

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

Required Optional

1

average_range
Required

The cells to average when all criteria pass.
2

criteria_range1
Required

The first range of cells to test.
3

criteria1
Required

The condition that cells in criteria_range1 must meet. It can be a number, text, cell reference, expression such as ">80", or wildcard pattern.
4

criteria_range2, criteria2
Optional Repeatable

Additional range-and-criteria pairs. Each extra criteria range must line up with average_range, and all criteria must pass before the matching value is included in the average.

Example

=AVERAGEIFS(D2:D50, B2:B50, "East", C2:C50, "Complete")

Average values in D2:D50 where B2:B50 is East and the matching cell in C2:C50 is Complete.

AVERAGEIFS caveats

The average range comes first

Unlike AVERAGEIF, AVERAGEIFS starts with average_range, then uses range-and-criteria pairs.
Criteria ranges must align

Every criteria range should cover the same rows or columns as average_range so each test lines up with the value being averaged.
All conditions are AND logic

A value is averaged only when every criteria pair passes for the same row or position.
Operators usually need quotes

Criteria such as ">80" or "<>Cancelled" must be written as text.
Only numeric average cells count

Blank or text cells inside average_range are skipped even when every criteria pair matches.