Counting Anything With COUNTA

The COUNT function only counts numbers. But real spreadsheets are full of text too: names, statuses, categories, and labels.

When you want to know how many cells have anything at all in them, you need COUNTA.

The extra A stands for "all" types of values. In this lesson you'll learn exactly what COUNTA tallies and when to reach for it.

COUNTA counts every cell that is not empty, no matter what kind of value it holds.

Its shape mirrors COUNT:

• =COUNTA(range)

Numbers, text, dates, TRUE/FALSE, and even error values all get counted. Only truly blank cells are skipped.

Imagine column A holds a guest list: "Maria", "Sam", "Priya", "Liam" in A1 to A4.

These are all text, so COUNT would return 0. But =COUNTA(A1:A4) returns 4, because all four cells contain something.

This makes COUNTA the right tool for counting names, labels, or any text entries.

COUNTA happily counts a mix of types. Suppose A1:A5 holds "Maria", 25, "Sam", 30, "Priya".

The formula =COUNTA(A1:A5) returns 5 because every cell has a value, whether text or number.

Compare that with =COUNT(A1:A5), which would return only 2, the two numeric cells.

COUNTA only skips one thing: truly empty cells.

If A1:A5 holds "Maria", (blank), "Sam", (blank), "Priya", then =COUNTA(A1:A5) returns 3.

This is exactly how you count how many rows actually have data, regardless of whether that data is text or numbers.

Here's a common surprise. A cell can look empty but still contain an empty text string, often left behind by a formula like =IF(B1>0, B1, "").

To COUNTA, that cell is not empty, so it gets counted. The cell shows nothing, yet your count goes up.

If your count seems too high, check whether formulas are producing invisible empty strings.

You're managing event sign-ups. Column A holds attendee names from A2 to A100, but only some rows are filled in so far.

To see how many people have registered, use:

• =COUNTA(A2:A100)

Because names are text, COUNT wouldn't help here. COUNTA counts every filled name and ignores the empty rows below.

Like COUNT, COUNTA accepts several ranges separated by commas.

Say names live in column A and column C. To count all filled entries across both:

• =COUNTA(A2:A100, C2:C100)

The non-empty cells from both ranges are added together into a single total.

Let's lock in the difference between the two:

• COUNT counts only numbers.
• COUNTA counts all non-empty cells (numbers, text, dates, logicals, errors).

If A1:A5 holds 10, "yes", 20, (blank), "no", then COUNT returns 2 and COUNTA returns 4. Pick the one that matches your question.

A great everyday use of COUNTA is finding how many records a table holds.

If your data starts in row 2 and each record has a name in column A, then =COUNTA(A2:A1000) tells you the record count, however many you have.

This number can then feed into other formulas, like building dynamic ranges or summaries.

COUNTA behaves identically in Microsoft Excel and Google Sheets. The same formula returns the same answer in either tool.

So whether you're counting attendee names in Excel or in Sheets, =COUNTA(range) reliably tells you how many cells hold a value of any kind.

This consistency means your counting skills travel with you no matter which spreadsheet you open.

Let's check your grasp of COUNTA.

You can now tally everything in a range, not just numbers. Key points:

• =COUNTA(range) counts all non-empty cells.
• It includes text, numbers, dates, TRUE/FALSE, and errors.
• It skips only truly blank cells.
• Watch out for empty strings ("") from formulas, which still get counted.
• Use it to count names, statuses, or the number of records in a table.

Next, we'll go the other way and count the blanks with COUNTBLANK.