COUNTIF()
Counts the cells in a range that meet a single condition.
COUNTIF(range, criteria)COUNTIF counts how many cells in range satisfy criteria — a number comparison, exact text match, or wildcard pattern like "North*".
To count based on multiple conditions, use COUNTIFS instead.
Arguments
- range
- The range to test against criteria.
- criteria
- The condition that decides which cells are counted.
Examples
=COUNTIF(A2:A200, "North")→37
Counts how many rows have North in column A.
=COUNTIF(B2:B200, "<>")→185
Counts non-blank cells — "<>" means not equal to empty.