# AVERAGE

AVERAGE( `value 1`, `[value 2 ...]` )

Averages a list of numbers, ignoring any blank values.

### Arguments

| Input          | Description                                                                                                               |
| -------------- | ------------------------------------------------------------------------------------------------------------------------- |
| `value 1`      | numeric column or value                                                                                                   |
| `[value 2...]` | Optional. Column(s) to be included in the calculation; will output a row-wise calculation when this argument is provided. |

### Outputs

Numerical average of input values

### Examples

Averaging a single column returns the average value of that column for every row.

{% embed url="<https://datawrapper.dwcdn.net/LCaBZ/1/>" %}

Averaging multiple columns returns the average by rows.

{% embed url="<https://datawrapper.dwcdn.net/Pr1ne/1/>" %}