AVERAGEIF

The AVERAGEIF function can be used to return the average value in a list if they meet a certain criterion.

Syntax

averageif( list, condition)

Arguments

list – The input list of values on which the filter is to be applied

condition – The condition to be evaluated

Return value

Returns the average value.

Example

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

Returns the average of values in Sales, Sales1, and Sales2 if they are greater than 0.1m.

AVERAGEIF used for calclating average of columns based on a condition