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

The average over all specified cell values.

Examples

Formula	Result	Comment
=AVERAGE(4, 5, 6, 7)	5.5	Average is 5.5