Excel AVERAGEIF Function (Average With One Condition) – Examples & Practice
Practice the Excel AVERAGEIF function online with an interactive grid, instant feedback, and clear formula help.
Instruction
Calculate the average of C2:C6 only for rows where A2:A6 equals "North".
Formula Syntax
=AVERAGEIF(range, criteria, [average_range])
- range: The range to evaluate with criteria.
- criteria: The condition that defines which cells to average.
- [average_range]: Optional actual cells to average.
What it does
AVERAGEIF calculates the average of cells that meet a single criterion. It mirrors SUMIF logic but returns a mean instead of a total.
Excel AVERAGEIF Function Examples
Average for one region
=AVERAGEIF(A2:A6, "North", C2:C6)
Averages C where A is North.
sales-by-region.xlsx
| A | B | C | |
|---|---|---|---|
| 1 | Region | Rep | Sales |
| 2 | North | Liam | 320 |
| 3 | South | Mia | 280 |
| 4 | North | Noah | 410 |
| 5 | West | Olivia | 295 |
| 6 | South | Paul | 360 |
| 7 | Output |
Input Formula
Need Help?
Tips
- Wrap with IFERROR for polished dashboards.
- Validate that matching rows exist before presenting KPIs.
- Move to AVERAGEIFS when you add dimensions.
AVERAGEIF Function Use Cases
- Average deal size for a segment
- Average score for a classroom group
- Simple conditional KPI reporting
- Teaching conditional aggregates
- Bridge to AVERAGEIFS for more filters
Common mistakes - AVERAGEIF function not working
- Mismatched ranges
- Expecting AVERAGEIF to ignore errors in the average_range
- Using AVERAGEIF when multiple filters need AVERAGEIFS
- Text vs number mismatches in criteria
- Forgetting IFERROR for empty-match cases
FAQ
AVERAGEIF vs AVERAGEIFS?
AVERAGEIF handles one criterion. AVERAGEIFS supports multiple criteria with a different argument order.
Does AVERAGEIF ignore zeros?
Zeros are numeric values and are included in the average if they meet the criterion.
What if no cells match?
You may see #DIV/0! because there is nothing to average.
Can criteria be an expression?
Yes, similar to SUMIF patterns like ">50" when quoted appropriately.
Can average_range be omitted?
If omitted, Excel averages the cells in range that meet the criterion when that makes sense for your data shape.
Comparison
| Function | Criteria |
|---|---|
| AVERAGEIF | One |
| AVERAGEIFS | Multiple |
| AVERAGE | None |
Example
=AVERAGEIF(A2:A6, "North", C2:C6)
Advanced examples
Weighted averages
AVERAGEIF is not weighted by default; weighted models typically use SUMPRODUCT patterns or helper columns.
Related functions
AVERAGEIFS is the natural upgrade when you need more than one criterion column; keep AVERAGEIF for the simplest single-condition case.
Mirror the same condition logic with SUMIF to show dollars next to averages, and anchor both to the same AVERAGE baseline when you publish definitions.