AVERAGE

Returns the average of specified cell values. Values which do not represent a number are ignored.

Syntax

=AVERAGE(Value1, [Value2], …)

Arguments

Name

Description

Value1

Cell or cell-range to calculate average for.

Value2, …

Optional. Additional Cells or cell-ranges to calculate average for.

Return Value

The average over all specified cell values.

Example

Function

Result

Comment

=AVERAGE(4, 5, 6, 7)

5.5