COUNTIF Generator
Create COUNTIF formulas for counting cells that match text, numbers, comparisons, or wildcards.
COUNTIF
Count cells that match a condition.
Cells Excel checks against the condition.
Condition to count. Text criteria need quotes.
=COUNTIF(A2:A100, "Complete")Checks Before You Paste
- •Use wildcards like "A*" to count text that starts with A.
- •Use COUNTIFS when you need multiple conditions.
- •Comparison criteria should be quoted, for example ">=10".