WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


Read, edit, and convert PDFs with the powerful PDF toolkit.


Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android


How to count cells with text in excel

July 26, 2022

Do you want to ignore all other cells and only count the number of cells that contain any or a certain amount of text? If so, WPS Excel offers a function specifically for that purpose. We'll walk you through using it. The COUNTIF function in Excel can be used to count cells that contain either specific text or any text. Use the approach listed below that is suitable for your particular circumstance.

How to count cells with any text in excel online, 2016 and 2019 

1.Use this technique to count the number of cells that have text but ignore any numbers, blank cells, or mistakes.

First, launch WPS spreadsheet and open your spreadsheet. Choose the cell in the spreadsheet where you wish to see the outcome.

2.Enter the COUNTIF function as shown below into the cell that has been selected. Ensure that the range containing the cells to be counted replaces D2 and D6 in this function.=COUNTIF(D2:D6,*)Here, the function is instructed to exclusively count text-containing cells using the * (asterisk) argument.

3.Additionally, you can count the cells that don't just contain text. Use the COUNTIF function modified as follows to do this. Only the cells that are not text should be counted in this function, according to the argument.A cell that has a mixture of text and numbers won't be tallied.=COUNTIF(D2:D6,*)

4.When you use the COUNTIF function to count the number of cells that contain any text, you will get the following result.

How to count cells with specific text in excel

1.Use an argument with the COUNTIF function to limit Excel's counting to cells that contain a certain amount of text.Select the cell in your spreadsheet where you wish to show the result first.

2.Enter the COUNTIF function as shown below into the cell that has been selected. Replace D2 and D6 in the function with the range containing your cells. Additionally, change a to any character or word that your cell must contain in order to be counted.The function below counts all cells that have the letter a in them. This means that in our example, since Mahesh and David both begin with the letter a, they will both be counted.=COUNTIF(D2:D6,*a*)

3.This is the result:

4.Remove the * (asterisk) symbol from before and after your character or word, as shown below, to have the function count the cells that contain only your selected character or word.=COUNTIF(D2:D6,a)

5.Since there are no cells in our example that solely contain the character a, the count result is 0.

Note: This above written article is an attempt to show you how to count cells with text in excel online, 2016 and 2019, in both windows and mac.You just need to have a little understanding of how and which way things work and you are good to go. With having this basic knowledge or information of how to use it, you can also access and use different other options on excel or spreadsheet. Also, it is very similar to Word or Document. So, in a way, if you learn one thing, like Excel, you can automatically learn how to use Word as well because both of them are very similar in so many ways. If you want to know more about WPS Office, you can download WPS Office to access, Word, Excel, PowerPoint for free.                                  

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.