SaltfishTry for free

How to Count Cells with Text Values in Microsoft Excel

·2 min read
In this article

Here's how to count cells with text values in MS Excel

  1. Click on the cell where you want the count result to appear and type the equals sign (=).
  2. Type 'COUNTIF' and select the function from Excel's autocomplete suggestions.
  3. Specify the range of cells you want to analyze for text values.
  4. Add a comma (,) to separate the range from the criteria parameter.
  5. Type the asterisk wildcard "*" in quotes to match any text content.
  6. Close the function with a parenthesis and press Enter to execute the formula.
  7. View the result showing the total count of cells containing text in your selected range.

Ready to get started with
interactive demos?

Try for free

Frequently Asked Questions

The asterisk (*) is a wildcard character that matches any sequence of characters in Excel. When used in COUNTIF, it tells Excel to count any cell that contains text, regardless of what that text says or how long it is.