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.