The COUNTIF function returns the count of items that match the specified condition.
countif(list, condition)
list - List of values. This is a required argument.
condition - The condition to be evaluated. This is a required argument.
COUNTIF([100,500,120],"<200")
Returns 2, since only two values in the given list, match the condition
COUNTIFarrow-up-right
Last updated 3 years ago
Was this helpful?
