← Back to level 2
Level 2Next
AVERAGEIF
A medium conditional average formula for one rule, useful when you want the mean of only the matching rows.
Syntax
=AVERAGEIF(...)Step-by-step explanation
- 1Choose the range that will be checked against your condition.
- 2Add the criteria so Excel knows which rows should count or sum.
- 3Review the result to make sure only matching rows were included.
Common mistakes
Averaging the wrong range
Using mismatched range sizes
Forgetting that text values are ignored in the average
Example table
A quick scenario to connect the syntax to the result.
| Sales | 80 |
| Sales | 90 |
| HR | 70 |
Formula
=AVERAGEIF(A1:A3,"Sales",B1:B3)
Result
85
Worked example
- 1Read the sample data first so you know what the formula needs to solve.
- 2Enter =AVERAGEIF(A1:A3,"Sales",B1:B3) in the result cell and press Enter.
- 3Check that the output matches 85.
Practice area
Use AVERAGEIF when a single condition should determine which values are included in the average.
Match against the syntax block above.
Real-life use cases
Department averagesFiltered score reportsTargeted performance reviews
Related formulas