COUNTIF
The COUNTIF function returns the count of items that match the specified condition.
Syntax
countif(list, condition)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