> For the complete documentation index, see [llms.txt](https://docs.cascade.io/cascade/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.cascade.io/cascade/functions-and-expressions/functions/aggregate/average.md).

# 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/>" %}