AVERAGEIF

The AVERAGEIF function returns the average of values in a list that meet a specified condition.

Syntax

AVERAGEIF( list, condition)

Arguments

• list: The list of values to evaluate.

• condition: The condition used to filter the values.

Return value

Returns the average of the values that satisfy the given condition.

Example

AVERAGEIF([Sales,Sales1,Sales2],">0.1m")

Returns the average of Sales, Sales1, and Sales2 column values when they are greater than 0.1 million.