How to count cells with text in Excel: step-by-step guide

Are you a Microsoft Excel user? We'll tell you How to count cells with text in Excel and also very step by step, so that you do not have any doubts. Tecnobits We are very fond of bringing you step-by-step guides to the Microsoft office suite, that is, Microsoft Office. And this time we are going to focus more on Microsoft Excel. Because we know that it creates many headaches, but it also gives a lot of joy when you know how to use it well and take advantage of it.

How to count cells with text in Excel is not as complicated as you think, but it is good to stop, read and learn at your leisure. In addition to that, We will bring you those little formulas, codes or functions that make your life easier with just a click of the mouse in Microsoft Excel. So, you don't have to worry as we are going to guide you through each step. Here we go with another article on Microsoft Excel in Tecnobits!

What's so great about counting cells with text in Microsoft Excel?

We already know what Excel is, so much so that on other occasions we have taught you How to Send Emails Directly from ExcelWe also know that it is a great and powerful tool that makes it easy to manage large amounts of data and therefore, to carry out a good analysis. We are not going to spend much more time on it. Because what we want is to learn now how to count cells with text in Excel.

Counting cells with text in Excel is very common even if it may not seem so. Knowing how many cells have text will help you organize your information, It will also help you analyze data and make decisions that are fully based on the results.That is, to make the most of Excel, and above all, to make it better.

An example would be if you have a spreadsheet with a large list of tasks written down, and you wanted to know how many of them have been completed, with a keyword entered such as "complete", knowing how to count cells with text in Excel will help you do this more easily. fast and efficient. But to do this you will need to know all the formulas with which to execute it.

Different formulas to count cells with text in Excel

 

There are different ways to learn how to count cells with text in Excel, but the main one is with formulas. And that is why we are now going with the solution to the article, formula by formula so that you can start using it. Let's go through each of these formulas:

• COUNTIF function: to count cells with text: one of the simplest and most effective to learn how to count cells with text in Excel. It will allow you to count cells that meet a specific criterion. In this case you will have to enter =COUNTIF(range, criteria) to count the cells. For example: =COUNTIF(A1:A10, "*")
• COUNTA function: This is another useful function for the same purpose. It will count all the cells that are not empty, regardless of whether they have text, numbers or any data. To do this you will have to enter =COUNTA(range). For example: =COUNTA(A1:A10). In some cases you can combine both functions, but if you have a data range that includes both parameters, it is better to use COUNTIF plus ISNUMBER to include numeric cells. Yes, it is a combination function and we show it to you below.
• Combined: As you have already understood the mechanics at this point, the combination is done in this way =SUM(–(ISNUMBER(A1:A10)=FALSE)) with this formula you will count how many cells have text and will exclude cells with numbers. We will differentiate text from the rest of the data.

Filter text with Excel

But it exists one last way to be able to filter cells with text in Microsoft Excel. If you thought you already knew how to count cells with text in Excel, you are wrong, you only know partially. We are missing one last method and we are going to go with it.

By using filters we will be able to count cells with text in Excel. Although it is true that we are not talking about a formula as such, it can also be helpful if all of the above is complicated for you. To do this, do this:

1. Select how many cells you want to filter
2. Click on the “Data” tab and then select “Filter”
3. You will see arrows appear on each column header. Now you will have to click on the arrow you want to filter and click on text filters.
4. Now choose between contains or does not contain as it suits you.
5. Once the filter is applied, you will see only the cells that contain text or not.

We hope you have learned how to count cells with text in Excel by now. We believe that it is essential to know how to use the program well, and that is why we put so much effort into these articles. Because We are users of Microsoft Excel in our daily life and we want to convey how good software is if you know how to use it correctly. See you in the next article!