AVERAGE

Returns the arithmetic mean of the numbers in a range.

Syntax

=AVERAGE(number1, [number2], …)

Arguments

number1 - The first number or range.
number2 (optional) - Additional numbers or ranges.

Examples

=AVERAGE(B2:B100)

Returns: Mean of the values

Blank cells are ignored; zeros are counted.

Common Errors and Gotchas

Empty cells are skipped, but cells containing 0 are included - this changes the result.
For a conditional average, use AVERAGEIF or AVERAGEIFS.

Does AVERAGE Work in Google Sheets?

Yes. AVERAGE uses the same syntax in Google Sheets and LibreOffice Calc, so you can paste these formulas straight across.

See Also