AVERAGE
Returns the average of specified cell values. Values which do not represent a number are ignored.
Syntax
=AVERAGE(Value1, [Value2, ...])
Arguments
| Name | Type | Description |
|---|---|---|
| Value1 | Range | Cell or cell-range to calculate average for. |
| Value2, ... (optional) | Ranges | Additional Cells or cell-ranges to calculate average for. |
Return
| Type | Description |
|---|---|
| Number | The average over all specified cell values. |
Examples
| Formula | Result | Comment |
|---|---|---|
| 5.5 | Average is 5.5 |