# AVERAGEIF

The AVERAGEIF function returns the average of the filtered values that satisfy the given condition.

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

```excel-formula
averageif([Range], Condition)
```

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

Range – List of values. This is a required argument.

Condition – Condition to be checked. This is a required argument.

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

```excel-formula
averageif([Column1],[Column2], “>10000”)
```

Returns the average of Column1 and Column2 if they are above 10000

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

[AVERAGEIF](https://support.microsoft.com/en-us/office/averageif-function-faec8e2e-0dec-4308-af69-f5576d8ac642)