StatisticalLevel: BeginnerAvailable in: Excel 2007+

In this article

1. Syntax
2. Examples
3. Example 1
4. Example 2
5. Power combo
6. Common errors and fixes
7. Related functions

AVERAGE returns the arithmetic mean: the sum divided by the count of numbers. Empty cells and text are ignored, but zeros are counted.

Syntax

=AVERAGE(number1, [number2], ...)

Argument	What it means
number1	Numbers, cells or ranges to average.

Examples

Example 1

=AVERAGE(C2:C31)

Average daily sales for the month.

Example 2

=ROUND(AVERAGE(C2:C31), 0)

Rounded to a whole number for reports.

Power combo

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

Average ignoring zero days (holidays), which AVERAGE would count.

Common errors and fixes

You see	Why, and the fix
#DIV/0!	No numbers in the range. Wrap it: =IFERROR(AVERAGE(C2:C31), 0).
Average too low	Zeros are included. Use AVERAGEIF(range, “<>0″) to exclude them.

Related functions

AVERAGEIFS · MEDIAN · SUM · COUNT

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

Keep reading

Excel Functions A–ZMID Function in Excel: Extract Text From the MiddleExcel Functions A–ZWEEKDAY Function in Excel: Day of the Week as a NumberExcel Functions A–ZMINIFS Function in Excel: Smallest Value Meeting Conditions