COUNTIF

The COUNTIF function can be used to return the count of values in a list if they meet a certain criterion.

Syntax

countif(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 count of values.

Example

countif([Units,Units1,Units2],">600")

Returns the count of stores where the number of units sold (Units, Units1, and Units2) is greater than 600.

COUNTIF to calculate the stores that sold more than 600 units of a product