How to Count Cells with Text Values in Microsoft Excel

‍

‍

It is very easy to count cells with text values in Microsoft Excel. Here’s a quick tutorial on how to do it:

‍

1. Inside your Microsoft Excel worksheet, select the cell you wish to use and then type an 'Equals' (=) sign.
2. After that, type 'Countif' and then select it from the suggested results.
3. Enter the cell range containing the text values you wish to count.
4. Subsequently, input a 'Comma' (,) to add conditions.
5. Enter an 'Asterisk' (*) sign enclosed in quotation marks to specify that you're counting cells with text values.
6. Once done, add a closing parenthesis and then tap 'Enter' or 'Return' to run the formula.
7. After completing these steps, the number of cells with text values from the selected range will be displayed for viewing.