Skip to content

How to Count Cells with Text

A popular question these days is – how do you count cells with text in a spreadsheet?

You can’t use the COUNT function because this will only count cells that contain numeric values.

Instead, you have to use the COUNTA function.

The COUNTA Function

The COUNTA function counts cells that contain any value. In other words, the COUNTA function will count all non-empty cells.

Take a look at the example below.

The COUNTA function looks at all the cells in B2:B8 and counts each one except the last one. That’s because the last cell is the only one that is empty.

Count Text But Not Numbers

You now know how to count cells that contain any value, including text. But what do you do if you want to count the cells that only contain text?

In other words, what if you don’t want to count the cells containing numbers and only want to count those containing text?

Here is what you can do.

Combine the COUNT and COUNTA Functions

To only count the cells containing text, you must write a formula using both the COUNT and COUNTA functions.

Your formula will look like this.

= COUNTA(range) - COUNT(range)

The COUNTA function will count all the cells containing any value, and the COUNT function will only count the cells containing numbers.

As you subtract the COUNT result from the COUNTA result, you are left with a count of only those cells containing text.

In other words, you are removing the number cells from the count.

COUNT and COUNTA Example

Here is a great example of the COUNT and COUNTA formula we just discussed.

The COUNTA function counts all non-empty cells and comes up with 7.

The COUNT function counts only those cells containing numbers and comes up with 4.

The number 4 is subtracted from 7, and we get a value of 3. And looking at the data, there are only three cells that contain text.

And that is how you can use the COUNT and COUNTA function to count cells with text.

This Post Has One Comment

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top