It is very easy to count cells with text values in Microsoft Excel. Here’s a quick tutorial on how to do it:
- 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.
