COUNT vs COUNTIF vs COUNTIFS
Counting in spreadsheets — from counting all numbers to counting only cells that meet specific criteria.
COUNT
Syntax
=COUNT(value1, [value2], ...)Example
=COUNT(A:A)✓ Pros
- • Simplest counting function
- • Works in all versions
- • Fast on any size dataset
✗ Cons
- • Only counts numeric cells — ignores text, blanks, TRUE/FALSE
- • No conditional logic
Use when…
You want a count of numeric cells only. For counting text or blanks, use COUNTA or COUNTBLANK instead.
COUNTIF
Syntax
=COUNTIF(range, criteria)Example
=COUNTIF(B:B, "Approved")✓ Pros
- • Single condition — very readable
- • Supports wildcards (* and ?)
- • Works in all Excel versions
✗ Cons
- • One condition only
- • Case-insensitive
Use when…
You need to count cells matching one condition — "How many rows have Status = Approved?"
COUNTIFS
Syntax
=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], ...)Example
=COUNTIFS(A:A, "North", B:B, "Approved")✓ Pros
- • Multiple AND conditions
- • Supports wildcards
- • Readable with many conditions
✗ Cons
- • All conditions are AND — OR requires multiple COUNTIFS added together
Use when…
You need a conditional count with 2+ criteria. The go-to for multi-condition counting in dashboards and reports.
⚡ Quick Verdict
**COUNT** for counting numbers. **COUNTIF** for one condition. **COUNTIFS** for multiple conditions. For OR logic, add multiple COUNTIFS: =COUNTIF(A:A,"X")+COUNTIF(A:A,"Y").
Try these formulas in the generator
Describe what you need in plain English and get the exact formula — including the right choice between these options.