Google Sheets function
AVERAGEIF function in Google Sheets
AVERAGEIF in Google Sheets calculates the mean of values associated with cells that meet one criterion. It can average the tested range or a separate aligned range. Use AVERAGEIF to compare averages for one category, status, person, or numeric threshold.
Source: Google Docs Editors HelpLast verified Nov 5, 2026
Syntax
=AVERAGEIF(criteria_range, criterion, [average_range])Arguments
| Argument | Required | What it means |
|---|---|---|
criteria_range | Yes | The range tested against the criterion. |
criterion | Yes | The pattern or test applied to the criteria range. |
average_range | No | The range whose values are averaged when it differs from criteria_range. |
Examples
Average sales for one region
| A | B | |
|---|---|---|
| 1 | Region | Sales |
| 2 | North | 10 |
| 3 | South | 12 |
| 4 | North | 20 |
| 5 | South | 18 |
=AVERAGEIF(A2:A5,"North",B2:B5)Result: 15
AVERAGEIF averages the two North sales values, 10 and 20.
Common mistakes
Using criteria and average ranges with different shapes.
Align the criteria range and average range row for row.
Trying to apply several conditions with AVERAGEIF.
Use AVERAGEIFS when the average depends on multiple criteria.