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
Returns 2, since only two values in the given list, match the condition
Excel equivalent
Last updated