What is COUNTIF?
Counts cells meeting a single criterion. Essential for frequency analysis, data validation, and finding duplicates.
Syntax
=COUNTIF(range, criteria)
Example
Formula: =COUNTIF(A2:A10, \
Result: 5
How It Works
Counts how many cells in A2:A10 contain values greater than 50. Can use text criteria like 'Apple' or operators like '>=100'. Wildcards (* and ?) are supported.