Description Returns the average of the supplied numbers. The result of AVERAGE is also known as the arithmetic mean.
Syntax AVERAGE ( number_list )
| Argument | Description |
|---|---|
| number_list | A list of up to 30 numbers separated by commas. The list may contain numeric values, cell references, range references, or array constants.Text and logical values in range references and array constants are ignored. Text entered in the argument list will be evaluated as a number, if possible; otherwise it will cause a #VALUE! error. Logical values entered into the argument list are evaluated as numeric 1 if TRUE and numeric 0 if FALSE. |
Examples This function returns 8.25:
This function returns 134, the average of the values in the range C15:C17:
