Count the cells in a range that meet a single condition.
COUNTIF works the same in Google Sheets and supports the same wildcards (* and ?).
COUNTIF(range, criteria)COUNTIF counts how many cells match one criterion — useful for tallies, finding duplicates, and quick quality checks. For multiple conditions, use COUNTIFS.
=COUNTIF(B2:B100, "Done")Result: 34
Counts how many tasks are marked Done.
=COUNTIF(A2:A100, A2)>1Result: TRUE
Flags duplicates: TRUE when a value appears more than once.
Use =COUNTIF(range, cell)>1 as a helper column or conditional-formatting rule — it's TRUE for any value that repeats.