COUNTIF
Last updated
Was this helpful?
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
Last updated
Was this helpful?
Was this helpful?