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

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