How to Count Cells with Text Values in Microsoft Excel
- George Apostolov
How to Count Cells with Text Values in Microsoft Excel: step-by-step guide
Inside your Microsoft Excel worksheet, select the cell you wish to use and then type an 'Equals' (=) sign.
After that, type 'Countif' and then select it from the suggested results.
Enter the cell range containing the text values you wish to count.
Subsequently, input a 'Comma' (,) to add conditions.
Enter an 'Asterisk' (*) sign enclosed in quotation marks to specify that you're counting cells with text values.
Once done, add a closing parenthesis and then tap 'Enter' or 'Return' to run the formula.
After completing these steps, the number of cells with text values from the selected range will be displayed for viewing.
Quick answer: To count cells with text values in Microsoft Excel, select a cell, type an equals sign, and choose Countif. Enter the cell range, add a comma, type an asterisk in quotation marks, add a closing parenthesis, and press Enter to view the result.
About this Microsoft tutorial
Count text cells in Microsoft Excel by using the Countif formula with a range and asterisk condition to quickly view the total. This guide shows how to count Cells with Text Values in Microsoft Excel in 7 steps, starting with "Inside your Microsoft Excel worksheet, select the cell you wish to use and then type an..." and finishing with "After completing these steps, the number of cells with text values from the selected ra...". The interactive demo above is a click-through copy of the real Microsoft interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to count Cells with Text Values in Microsoft Excel?
7 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your Microsoft data or settings. Once you know the flow, repeat it in your own workspace.
This tutorial is filed under Microsoft and Excel. Related guides: How to Count the Words in Microsoft Excel, How to Create a Chart in Microsoft Excel and How to Create a Custom Formula in MS Excel. Last reviewed 05 Oct 2026.
Create your first interactive demo in minutes
No credit card required • Start building today
