Syntax
=AVERAGEIFS(average_range, criteria_range1, criterion1, [...])
average_range- The cells to average (comes first).
criteria_range1- The first range to test.
criterion1- Its condition.
...- Optional. More range/condition pairs.
AVERAGEIFS function in Google Sheets
AVERAGEIFS averages values from rows that meet every condition you list. It's the multi-condition version of AVERAGEIF.
Practice AVERAGEIFS
Task 1 of 1
Using AVERAGEIFS, find the average score of class B students who passed (score of 60 or more). Answer in E2.
Tip: while typing a formula, click a cell or drag across cells to insert references. Press Enter to check, and Tab to accept a function suggestion.
AVERAGEIFS examples
Each example below runs against this sample sheet. The results are calculated by the same engine as the practice grid.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Rep | Region | Product | Units | Revenue |
| 2 | Ava | West | Monitor | 12 | $2,400.00 |
| 3 | Liam | East | Keyboard | 30 | $1,500.00 |
| 4 | Maya | West | Mouse | 45 | $900.00 |
| 5 | Noah | North | Monitor | 8 | $1,600.00 |
| 6 | Zara | East | Monitor | 15 | $3,000.00 |
| 7 | Omar | West | Keyboard | 22 | $1,100.00 |
| Formula | Result | What it shows |
|---|---|---|
=AVERAGEIFS(E2:E7, B2:B7, "West", D2:D7, ">10") | $1,466.67 | West deals with more than 10 units. |
=AVERAGEIFS(D2:D7, C2:C7, "Monitor", B2:B7, "<>North") | 13.5 | Monitor units outside the North. |
Tips and common mistakes
- Same argument order as SUMIFS: the range you're averaging goes first.
Related functions
Learning step by step? AVERAGEIFS is covered in Lesson 15: AVERAGEIF Function of the free course.