FILTERIF

The FILTERIF function filters a list of values based on a specified condition and returns the filtered results as an array.

Because it returns an array, it is typically used with aggregate functions such as SUM or AVERAGE. It can also be used to populate a calculated row.

Syntax

FILTERIF(list, condition)

Arguments

• list: The list of values to evaluate.

• condition: The condition used to filter the values.

Return value

Returns an array of values that meet the specified condition.

Example

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

Filters values from Sales, Sales1, and Sales2 that are greater than 0.1 million and returns their sum.