# AVERAGE

The AVERAGE function returns the average (arithmetic mean) of its arguments, which can be numbers or node references.

### Syntax <a href="#syntax" id="syntax"></a>

```
average(value1,[value2]....)
```

### Arguments <a href="#arguments" id="arguments"></a>

value1 – The first node or number to be averaged. This is a required argument.

value2,...– The additional nodes or numbers to be averaged. These are optional arguments.

### Example <a href="#example" id="example"></a>

```
average(COLUMN1, COLUMN2)
```

Returns the average of COLUMN1 and COLUMN2

### Excel equivalent <a href="#excel-equivalent" id="excel-equivalent"></a>

[AVERAGE](https://support.microsoft.com/en-us/office/average-function-047bac88-d466-426c-a32b-8f33eb960cf6)