The AVERAGE function

Returns the mean: the sum of the numbers divided by how many there are. Blank cells and text are skipped.

Syntax

AVERAGE(number1, [number2], ...)
number1
The first number, cell or range.
number2 (optional)
More numbers or ranges.

Examples

E1=AVERAGE(C2:C6)
ABCDE
1RegionProductSales330
2NorthShoes500
3SouthShoes300
4NorthBags250
5NorthShoes420
6SouthBags180
B1=AVERAGE(2,4,9)
AB
15

Practice AVERAGE

Read the guide

Questions

Does AVERAGE count blank cells?

No. Blank cells and text are skipped, so they do not pull the average down. A cell that holds 0 does count.

How do I calculate an average with a condition?

Use AVERAGEIF. =AVERAGEIF(A2:A6,"North",C2:C6) gives the average of sales in the North region. For several conditions, use AVERAGEIFS.

How do I average without zeros?

Use AVERAGEIF with the condition "<>0", as in =AVERAGEIF(C2:C6,"<>0"). Cells that hold 0 no longer count, and blank cells are skipped as always.

How do I round an average?

Wrap AVERAGE in ROUND, as in =ROUND(AVERAGE(C2:C6),1) for one decimal place. To show fewer decimals without changing the number, use Decrease Decimal on the Home tab.

What is the difference between the average and the median?

The average is the sum divided by the count. The median is the middle number when the numbers are in order, and one very large number does not pull it up. Use MEDIAN to find it.

Related functions