# How to count cells with text in Excel

A free Office suite fully compatible with Microsoft Office

A free Office suite fully compatible with Microsoft Office

Every component can be easily saved in Excel for financial analysis in any business. People today utilize Excel in a very modern way to provide the finest outcomes for their work. The formula for counting cells with text is another Excel feature. Excel spreadsheets are used to manipulate numerical data. But now we also use them a lot for manipulating and storing text. Excel is also capable of performing this task, but particular steps must be taken..

In this tutorial, we will find the methods to find counting cells with text formula in Excel.

The first method to find the count number of cells with text is below in steps wise.

1) We will use the COUNTIF formula to find out the counting cells with text formula in excel.

The Formula is COUNTIF(range, *).

2) Draw a chart as an example to show how to count some cells with text.

3) Now use the formula to find the text and imply it in A2.

4) Now press Enter key and your answer will automatically appear in the C2 box, like that.

Congratulations you easily found the counting cells with the text formula of COUNTIF in excel with all these easy steps.

How to find Count of cells with Text formula In Excel with another formula.

This method can also perform under the same method as above but here we will use another formula to find how to count cells with the text formula.

This also includes some functions and steps which are given below.

1) Here we will use the formula of SUMPRODUCT(--TEXT(range))

2) This is the second formula by which we will find how to count cells with the text formula.

3) Our third step is to make an example in a spreadsheet and after that imply the formula in it step by step.

4) Now our fourth step is to place the formula in the C2 box so automatically the answer will appear again with the second formula.

5) After that press enter and the answer will appear in C2 like this.

Congratulation you again find how to count cells with text formula in excel with another method and formula.

How To count cells with text formula In Excel with the third formula.

We can easily find how to count cells with text formula in excel with one more formula and to cover this function we also require some steps and their methods to follow.

Their steps are given below.

NOTE: As mentioned above that there is some text which can be calculated and some are not, the attached example will follow all these 3 formulas.

1) We will again use the SUMPRODUCT formula in it but there is some difference between the second formula and this one.

2) The formula which we use here is:=SUMPRODUCT(TEXT(A2:A10)*1)

3) The first step is to make an example on a spreadsheet where we will imply this formula and find the solution of text.

4) The second step is to place the formula in the C2 bar by which we will find the answer.

5) After that press enters and your answer will automatically appear in the C2 box like this.

6) Now our last step is to copy the formula in all the bars and your answer will appear in all the boxes like that.

Congratulations by following all these you again find the count of cells with text in excel with the third formula without any hassle.

You can also find this feature in the latest excel versions 2016/2018/2019 spreadsheet, where you can easily find the right way to find how to count cells with text formula in excel.

Did you learn about how to count cells with text formula in excel? You can follow WPS Academy to learn more features of Word Document, Excel Spreadsheets, and PowerPoint Slides.

You can also download WPS Office to edit word documents, excel, and PowerPoint for free of cost. Download now! And get an easy and enjoyable working experience

Was this helpful?

Yes

No

Trending Tutorials

- 1. How to get month name from a date in Excel (3 easy ways)
- 2. Check if value is in list in Excel (3 easy methods)
- 3. How to Copy File Names in Excel from a Folder?
- 4. How to color cell based on value in Excel?
- 5. How to add text to beginning or end of all cells in Excel
- 6. How to compare two excel sheets and highlight differences