Count Cells That Contains Text or Specific Text

This post will guide you how to count the number of cells that contain text or the specific text in Excel. How do I count the number of cells if they contain text using excel formula.

Count Cells That contains text


If you want to count the number of cells that contain text, you can use the COUNTIF function and a wildcard to create a new Excel Formula. Just like below this:

=COUNTIF(B1:B4,"*")

count cells contains text1

The COUNTIF function will count the number of cells that match the given criteria. And the wildcard character will match any number of text characters.

If you want only to count the number of cells that contain specific text in a range, you still need to use the COUNTIF function with the specific characters and wildcard character. For example, to count the number of cells that contain “excel” text string, you can write down the following formula:

=COUNTIF(B1:B4,"*excel*")

count cells contains text2

Related Functions


  • Excel COUNTIF function
    The Excel COUNTIF function will count the number of cells in a range that meet a given criteria. This function can be used to count the different kinds of cells with number, date, text values, blank, non-blanks, or containing specific characters.etc.= COUNTIF (range, criteria)…
Related Posts

Excel Structure Reference

This tutorial introduces the basics of structured referencing in Excel and shows you how to use structured referencing in a table with examples. When you use formulas that reference tables, whether the formula references a part of the table or ...

Excel/Google Sheets: Full Row Reference

Excel or Google sheets supports both full row references and full column references. This article will talk about the usage of full row references. Full Row reference is another cell reference in Excel or Google Sheets, which is used to ...

Excel/Google Sheets: Full Column Reference

Full column reference is another cell reference in Excel or Google Sheets, which is used to reference the entire column, for example, if you want to reference the entire column A, you can use the following reference format A: A. ...

Excel/Google Sheets: Expanding Reference

An expanding reference is a reference type in Excel and Google worksheets that extends the range of a cell when a formula is copied to the cell below or to the right. In this article, we will explain how to ...

Excel/Google Sheets: Mixed Reference

In Microsoft Excel Spreadsheet or Google sheets, there is another cell reference, mixed references, where part of the reference is absolute, part of the relative. This article will describe how to use mixed references through specific examples. Mixed Reference When ...

Sidebar