Beginner
Statistical
COUNTIF
Counts the number of cells in a range that meet a single condition.
Compatibility: All Excel versions
Syntax
=COUNTIF(range, criteria)
Example
=COUNTIF(A1:A20,"Yes")
When to Use It
Use COUNTIF to count how many times something appears — how many orders are marked "Shipped", or how many scores are above a threshold.