Skip to content

AVERAGE

Statistical

AVERAGE helps you perform summary and inferential functions for descriptive and statistical analysis.

Overview

Start with "=" then enter AVERAGE(number1, [number2], ...). Keep argument order as shown and use cell ranges where appropriate.

Parser pathComplete docs

Syntax & Arity

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

1+ arguments

Arguments

ArgumentRequiredTypeDescription
number1RequiredSingleNumeric input value.
number2OptionalSingleNumeric input value.

Example Inputs & Outputs

Formula

=AVERAGE(A1:A5)

Example Output

8.4

Returns the arithmetic mean for the selected values.

Related Functions