AVERAGE

Syntax:

AVERAGE ( argument-list )

Description: Computes the arithmetic mean of the numeric values of its arguments.

Arguments:

Name

Type

Description

argument-list

logical, number, name, text, or reference that contains a number.

The arguments in argument-list designate the values to be averaged. An argument that is a logical value or the text representation of a number shall be counted. If an array or cell reference argument contains logical values, text, or empty cells, those values shall be ignored; however, cells having the value 0value 0 shall be counted.
Note: : The function AVERAGEA
3.17.7.18) does include cell reference arguments that refer to logical values or text representations of numbers. ]

Return Type and Value: number – The arithmetic mean of the values of its arguments.

example: