COUNTIF

The COUNTIF function returns the count of items that match the specified condition.

Syntax

Arguments

list - List of values. This is a required argument.

condition - The condition to be evaluated. This is a required argument.

Example

COUNTIF([100,500,120],"<200")

Returns 2, since only two values in the given list, match the condition

Excel equivalent

COUNTIF