AVERAGEIF Function in Excel: Average With One Condition

⏱ 1 min readUpdated 28 September 2026

StatisticalLevel: IntermediateAvailable in: Excel 2007+

In this article
  1. Syntax
  2. Examples
  3. Example 1
  4. Example 2
  5. Related functions

AVERAGEIF averages values that meet one condition — often used to ignore zeros.

Syntax

=AVERAGEIF(range, criteria, [average_range])
Argument What it means
average_range Cells to average (defaults to range).

Examples

Example 1

=AVERAGEIF(C2:C31, ">0")

Average daily sales ignoring closed days.

Example 2

=AVERAGEIF(B:B, "North", E:E)

Average North order.

AVERAGEIFS · AVERAGE

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Keep reading

Excel Functions A–ZSUMIF Function in Excel: Sum Values That Meet One ConditionExcel Functions A–ZSQRT Function in Excel: Square RootExcel Functions A–ZINTRATE Function in Excel: Interest Rate of a Fully Invested Security
✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Free · AI can be wrong