Returns the number of occurrences of given element within a cell range.
Sample Usage
COUNTIN(C4:E5,20)
COUNTIN(C4,C5)
Syntax
COUNTIN(range, element)
- range - The range to consider while counting.
- element - The element to be counted.
Examples
COUNTIN(C4:E5,20) returns a count of the occurrence of the number 20 in the range C4:E5.