How to Use the AVERAGEIFS Function in Google Sheets

By Tomosuke Hasegawa · Updated Oct 29, 2026 · Intermediate · 6 min read · includes 2 free exercises

In short: AVERAGEIFS averages a range for the rows that meet every condition. The formula is =AVERAGEIFS(average_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...]).

What AVERAGEIFS does

AVERAGEIF handles one condition. AVERAGEIFS handles several, such as "the average sales for the East region where quantity is above 1". A row counts only when it meets all of the conditions. It is the averaging cousin of SUMIFS and COUNTIFS.

AVERAGEIFS syntax

=AVERAGEIFS(average_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])

The average range comes first here, which is the opposite of how some people expect it. Google's examples include AVERAGEIFS(A1:A10, B1:B10, ">20", C1:C10, "<30").

A step-by-step example

Here are four rows of region, sales and quantity in cells A1:C5.

ABC
1RegionSalesQty
2East101
3West202
4East303
5West404
=AVERAGEIFS(B2:B5, A2:A5, "East")

This returns 20, the average of the East sales 10 and 30.

=AVERAGEIFS(B2:B5, A2:A5, "East", C2:C5, ">1")

This returns 30. Here is why: only the East row with quantity 3 meets both conditions, and the average of one value is that value.

Common mistakes

Try it yourself

Use the table above (A1:C5). Type your formula into the box, starting with =, then press Check.

Exercise 1: East average

Write a formula that averages B2:B5 for the rows where the region in A2:A5 is East.

Hint: average range first.

Exercise 2: Two conditions

Write a formula that averages B2:B5 for East rows where the quantity in C2:C5 is greater than 1.

Hint: add a second range and condition.

What to learn next

Syntax and rules in this guide were checked against Google's AVERAGEIFS help page. See all guides.