Article updated on April 13, 2018

Calculates the average of numbers in a cell range. In other words, the sum of a group of numbers and then dividing by the count of those numbers.

Excel function syntax

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

Arguments

number1 - numbers or a cell range

[number2] - Optional, additional arguments up to 255

Comments

Here is how the AVERAGE function works:

Cells B4 and B7 are empty, they are not counted.

Cells B4 and B7 contain text, they are not counted.

Cells B4 and B7 contain 0 (zeros), they are counted.

Boolean values in a cell range are not counted, however, if you enter boolean values in an argument, see cell B13 above, they are counted.

Download Excel *.xlsx file

AVERAGE function.xlsx