Excel AVERAGEIFS Function — Average with Multiple Conditions

Contents

What does AVERAGEIFS do?
Syntax
5 real examples
AVERAGEIFS vs AVERAGEIF
FAQ

What does AVERAGEIFS do?

AVERAGEIFS calculates the mean of values where all conditions are true simultaneously. It is the multi-condition version of AVERAGEIF. Where AVERAGEIF handles one condition, AVERAGEIFS handles two, three, or more — all checked against the same row at the same time.

The logic is AND — every condition must be true for a row to be included in the average. This lets you drill down to very specific subsets: average Coffee sales (condition 1) in the North region (condition 2) in Q1 2026 (conditions 3 and 4) for Active accounts only (condition 5).

Syntax

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

Argument	Description
average_range required	The column with numbers to average. This comes FIRST — unlike AVERAGEIF where it comes last.
criteria_range1 required	The first column to check a condition against.
criteria1 required	The first condition to match.
criteria_range2, criteria2 optional	Additional condition pairs. All must be true for a row to count. Up to 127 pairs.

⚠️ average_range comes FIRST in AVERAGEIFS

In AVERAGEIF, average_range is the third argument. In AVERAGEIFS it is the first. This is the single most common mistake when switching between the two.

5 real examples

Example 1

Average Coffee sales in the North

=AVERAGEIFS(C2:C100, A2:A100, "Coffee", B2:B100, "North")

Column A = product, B = region, C = sales. Only rows matching both conditions are averaged.

Example 2

Average above zero in one category

=AVERAGEIFS(C2:C100, A2:A100, "Active", C2:C100, ">0")

Combines a text condition with a numeric condition — only Active rows with positive values.

Example 3

Average in a date range

=AVERAGEIFS(C2:C100, A2:A100, ">="&DATE(2026,1,1), A2:A100, "<="&DATE(2026,3,31))

Q1 2026 average — two conditions on the same date column bracket a range.

Example 4

Dynamic criteria from cells

=AVERAGEIFS(C2:C100, A2:A100, E1, B2:B100, E2)

E1 and E2 hold the filter values. Change them and the average updates instantly — this is how dashboards are built.

Example 5

Three conditions

=AVERAGEIFS(D2:D100, A2:A100, "Coffee", B2:B100, "North", C2:C100, "2026")

Product = Coffee AND Region = North AND Year = 2026. Every condition must be true.

AVERAGEIFS vs AVERAGEIF

Feature	AVERAGEIF	AVERAGEIFS
Number of conditions	1	1 to 127
average_range position	3rd argument	1st argument
When to use	One filter	Two or more filters

💡 Use AVERAGEIFS for everything

AVERAGEIFS works for one condition too — making it a universal replacement for AVERAGEIF. Many Excel professionals just use AVERAGEIFS all the time.

FAQ

What happens if no rows match all conditions?

AVERAGEIFS returns #DIV/0! — nothing to average. Wrap with IFERROR: =IFERROR(AVERAGEIFS(...),"No data").

Can I use OR logic with AVERAGEIFS?

AVERAGEIFS uses AND logic only. For OR logic, average two AVERAGEIFS results weighted by their counts: =(AVERAGEIFS(C:C,A:A,"North")*COUNTIFS(A:A,"North")+AVERAGEIFS(C:C,A:A,"South")*COUNTIFS(A:A,"South"))/(COUNTIFS(A:A,"North")+COUNTIFS(A:A,"South")).

Can AVERAGEIFS use wildcards?

Yes — same as AVERAGEIF. Use * for any characters and ? for exactly one character in text criteria.

Practise AVERAGEIFS

ExcelPro has multi-condition exercises across all tracks. Free to start.

Try exercises →

Related formulas

AVERAGEIF SUMIFS COUNTIFS AVERAGE MAXIFS MEDIAN

The Excel AVERAGEIFS Functionexplained simply