Summary

AVERAGEIF returns the average of values that meet one condition. It is useful when you do not want the mean for the whole dataset and only care about one group, one threshold, or one matching label.

That makes it a practical reporting function. Instead of filtering a list by hand and then averaging it, you can let one formula do both jobs at once. You tell Excel what to check, what rule to use, and which numbers should be averaged.

Syntax

=AVERAGEIF(range, criteria, [average_range])

range is the part Excel checks against your rule. criteria is the rule itself. average_range is the set of values to average if it is different from the checked range.

Arguments

• range - [required] The cells Excel tests against the condition.
• criteria - [required] The rule that decides which cells count. This can be text, a number, an expression like ">1000", or a cell reference.
• average_range - [optional] The actual cells to average. If you leave it out, Excel averages the cells in range.

AVERAGEIF vs Other Functions

The difference mostly comes down to how many conditions you need and whether you want an average at all.

Using the AVERAGEIF Function

A common pattern is averaging one numeric column based on labels in another column. For example, you can average salaries where the department is "Sales", or average order values where the region contains the word "North". This keeps the formula readable even when the dataset grows.

Microsoft also notes a few details that help avoid mistakes. Criteria can be written as text, numbers, expressions, or cell references. That means rules like "Sales", 32, ">32", and B4 are all valid. If you omit average_range, Excel averages the matching cells from range itself.

Wildcards are useful when the text is not identical in every row. The asterisk * matches any sequence of characters, and the question mark ? matches a single character. That lets one formula catch values like North East and North West without listing each one separately.

Example 1 - Average salaries for Sales

Here the condition is a text label, so Excel checks the department column and averages the matching salary values.

=AVERAGEIF(A1:A3,"Sales",B1:B3) // Averages only the Sales rows.

Example 2 - Average values above 1000

This version uses a comparison rule. Because the values being checked and averaged are in the same range, average_range is not needed.

=AVERAGEIF(B1:B10,">1000") // Averages only values greater than 1000.

Example 3 - Average rows that contain North

The wildcard makes the match flexible, so Excel includes any entry that contains the word North.

=AVERAGEIF(A1:A10,"*North*",B1:B10) // Averages all matching North rows.

Example 4 - Use a cell as the condition

This is handy for reusable reports because the formula changes when the value in the criteria cell changes.

=AVERAGEIF(A1:A10,C1,B1:B10) // Uses the rule stored in C1.

Conclusion Recap

• Main job: AVERAGEIF returns the mean for values that match one condition.
• Flexible criteria: You can use text, numbers, operators, wildcards, or cell references.
• Optional average range: If you leave it out, Excel averages the matching cells in range.
• Wildcard support: * matches many characters and ? matches one.
• No matches: If nothing meets the condition, the result is #DIV/0!.
• Next step: Use AVERAGEIFS when one condition is not enough.