AVERAGE

Returns the average of the specified arguments.

Syntax

AVERAGE( Number n1, [Number n2], ... ) → Number

Parameters

n1
n2
…

One or more numbers to average.

Remarks

The arguments can be either numbers or cells, ranges, or arrays that contain numbers. Logical values, text, and empty cells are ignored. The specified arguments must contain at least one number or the function will return the #DIV/0! error value.

Example

Formula

=AVERAGE(A1:A10)
=AVERAGE(A1:A10,50)

See Also

Function Reference
SUM Function
COUNT Function