Summary

COUNTA returns how many cells are not empty. It does not matter whether the cell contains text, a number, a date, an error, or even a formula result. If the cell is not empty, COUNTA counts it.

This makes it useful when you want a completion count instead of a numeric count. Guest lists, forms, checklists, notes columns, and mixed data tables are all good places to use it.

Syntax

=COUNTA(value1, [value2], ...)

You can use a range, separate cells, typed values, or a mix of them.

Arguments

• value1 - [required] The first value, reference, or range to check.
• value2, ... - [optional] Additional values, references, or ranges to include.

COUNTA vs Other Functions

Using the COUNTA Function

The easiest way to think about COUNTA is that it counts presence. If something is in the cell, COUNTA includes it. That means it is often the better choice when you want to know how many responses, entries, or filled rows exist in a list.

It is especially useful in mixed datasets where some cells contain names, some contain numbers, and some contain notes or codes. COUNT would miss many of those entries because it only cares about numbers, but COUNTA still counts them because the cells are not empty.

One detail that often surprises people is that a cell can look empty and still be counted. If a formula returns an empty string like "", or if a cell contains a hidden space, COUNTA still treats that cell as non-empty. When a result seems too high, that is usually the first thing to check.

Example 1 - Count filled cells in a name list

This is useful for sign-up lists, attendance sheets, and any simple list where blanks mean no response yet.

=COUNTA(B1:B10) // Returns how many cells in the range are not empty.

Example 2 - Count mixed entries

Text and numbers both count here, which makes COUNTA a better fit than COUNT for mixed columns.

=COUNTA(A1:A10) // Counts all filled cells, regardless of value type.

Example 3 - Check form progress

If you only need to know how many cells have been filled in so far, COUNTA gives you a quick progress number.

=COUNTA(C1:C10) // Returns how many cells in the range contain an entry.

Example 4 - Audit a filled range

This is a simple way to compare how much of a range is active versus still blank.

=COUNTA(B1:B10) // Returns the number of non-empty cells in the range.

Conclusion Recap

• Main job: COUNTA counts cells that are not empty.
• Data type does not matter: Text, numbers, dates, errors, and formulas can all count.
• Good for completion checks: It works well for forms, lists, and mixed datasets.
• Watch out for cells that only look empty: Formulas returning "" and hidden spaces still count.
• When not to use it: If you only want numeric cells, use COUNT.
• Related check: Use COUNTBLANK when you want the missing side of the same range.