Skip to content

How to count cells with text in Excel?

  • by
  • 3 min read

Microsoft Excel is a flexible and powerful tool that offers various functions to analyse and manipulate data. Among its many capabilities, Excel allows users to count cells containing text easily. Whether you’re working with a dataset containing employee names, product descriptions, or any other textual information, accurately counting these cells can provide valuable insights into your data.

In this article, we have discussed how to count cells with text and cells with particular text in a few simple and easy steps.

Also read: How to add bullet points in Excel?

Count cells with text

If you want to count how many cells contain text in an Excel document, using the COUNTIF function with an asterisk in the criteria argument is the simplest and most effective method. As the asterisk (*) serves as a wildcard capable of matching any sequence of characters, this formula counts all cells containing any form of text.

For counting cells with text in the spreadsheet, select a cell where you want to see the result and input the formula =COUNTIF(range, criteria). In this context, range refers to the group of cells where you want the formula to look, while criteria represent what you’re searching.

For instance, We have entered =COUNTIF(A1:A20,”*”); the formula acts on cells from A1 to A20 and finds the text values.

The result is 18.

Also read: How to add a watermark to PowerPoint?

Count cells with a particular Text value

To count specific words in the Excel document type the same formula =COUNTIF(range, criteria), except this time, in criteria, put the word you want to find. For instance, we want to find the word Midmarket in cells from A1 to A20 so that we will type the formula =COUNTIF(A1:A20,”midmarket”).

The result is 6, and as you can count yourself, the cells with the word midmarket are six.

Also read: How to highlight duplicates in Excel?


Akash Singh

Akash is a law graduate who likes to go for bike rides on the weekends soul-searching for answers to his many existential questions. You can contact him here: [email protected]