← Back to level 2
Level 2Next
AVERAGEIFS
A medium conditional average formula for multiple rules, useful when the average should only include rows that match every filter.
Syntax
=AVERAGEIFS(...)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
Using ranges that do not line up
Misordering the criteria pairs
Expecting unmatched rows to still affect the result
Example table
A quick scenario to connect the syntax to the result.
| 12 | 18 |
| 8 | 68 |
Formula
=AVERAGEIFS(A1:B2)
Result
68
Worked example
- 1Read the sample data first so you know what the formula needs to solve.
- 2Enter =AVERAGEIFS(A1:B2) in the result cell and press Enter.
- 3Check that the output matches 68.
Practice area
Use AVERAGEIFS when the average depends on two or more matching conditions.
Match against the syntax block above.