Description
The AVERAGE function calculates the arithmetic mean of a list of numbers.
Usage
The function is used to find the average value of one or more numbers.
Syntax:AVERAGE(number1, [number2], …)
Examples
-
Calculate Average from Columns:
AVERAGE(#[number1], #[number2])This calculates the average of the values in the number1 and number2 columns.
-
Calculate Average from Calculations:
AVERAGE(#[calculation1], #[calculation2])This calculates the average of the results of two calculations, calculation1 and calculation2.
Inputs
| Argument | Data Type | Description |
|---|---|---|
| number1 | Number | The first number to include in the average. |
| [number2] | Number | (Optional) Additional numbers for the average. |
Returns
Type: Number
- Returns the arithmetic mean of the provided numbers.