COUNTA - Count populated cells
Measure how many fields have something in them, and understand why populated does not always mean valid or complete.
By the end, you can
- Count populated cells of different types.
- Explain empty-string and error behavior.
- Choose COUNTA or COUNT for a reporting question.
Before you start: Know the difference between a cell's address and its value.
In this lesson
How many contact fields were entered?
COUNTA counts cells that contain a value: text, numbers, logical values, and errors can all contribute. An outreach team can use it to measure populated email fields, but it cannot confirm that those fields contain valid email addresses. Each populated cell contributes one, regardless of its text length.
Syntax and arguments
=COUNTA(value1, [value2], ...)Pass the cells or ranges you want to check. Optional arguments let you combine separate areas.
| Argument | Purpose | Example |
|---|---|---|
value1Required | The first range, reference, or value. | B2:B6 |
value2, …Optional | More values or ranges, up to 255 arguments total. | D2:D6 |
An outreach contact checklist
4| A | B | C | D | |
|---|---|---|---|---|
| 1 | Customer | Contact | Populated | |
| 2 | Apex | sales@apex.test | 4 | |
| 3 | Bright | |||
| 4 | Core | Pending | ||
| 5 | Delta | hello@delta.test | ||
| 6 | Elm | info@elm.test |
=COUNTA(B2:B6)Three email strings and the word Pending count. Bright's empty field does not.
Combine areas and compare with COUNT
=COUNTA(B2,B5)Both selected contact cells are populated.
=COUNT(B2:B6)All populated contact values in this example are text, so COUNT returns zero.
=COUNTA("")A zero-length text value is a value, not a genuinely empty cell.
In a real checklist, COUNTA can combine name and phone ranges. That counts fields, not unique customers: one customer with both fields populated contributes twice.
Visually empty is not necessarily empty
- Numbers, including zero, text, TRUE/FALSE values, and errors are counted.
- A formula returning "" is counted even though the cell looks empty.
- A cell containing only spaces is text and counts. Clear unwanted contents rather than relying on appearance.
- A truly empty cell is skipped. Formatting an otherwise empty cell does not give it a value.
Common mistakes and fixes
Check your understanding
Choose an answer for instant feedback. You can try again; answers stay only on this page.