What it does
COUNTA counts cells that are not empty.
Syntax or pattern
=COUNTA(value1, [value2], ...)✅
5 practical examples
1
Count filled names
Count non-empty names in a list.
=COUNTA(A2:A100)Text, numbers and dates are counted.
2
Count submitted tasks
Count rows with any task title.
=COUNTA(Tasks[Task])Useful for simple task trackers.
3
Count filled survey responses
Count non-empty response cells.
=COUNTA(Survey[Answer])Counts any visible entry.
4
Count several columns
Count non-empty values in two columns.
=COUNTA(A2:A100,C2:C100)Works across multiple ranges.
5
Compare filled vs numeric
Use COUNTA beside COUNT.
=COUNTA(B2:B100)-COUNT(B2:B100)This can reveal text values in a numeric column.
Common mistakes to avoid
- Selecting ranges with different sizes.
- Using text values where numbers are required.
- Forgetting how blanks and hidden rows are treated.
Related Excel examples
FAQ
Can this formula use Excel Tables?
Yes. Structured references often make summary formulas easier to read.