# How to Count Cells That Begin with Specific Text in Excel

This post will guide you how to count cells that begin with a specific text string in a given range cells using a formula in Excel 2013/2016.How do I count cells the number of cells that begin with a certain text string in Excel.

## Count Cells that Begin with Specific Text

Assuming that you want to count the number of cells that have the certain letters(“excel”)from the word approved as the first five characters in a selected range(A1:A6).In this case, you can use a formula based on the COUNTIF function.

Enter the following formula in a blank cell, and press Enter key:

=COUNTIF(A1:A6,”excel*”) Note: A1:A6 is the data range that you want to use. “excel*” is a condition that that data need to be matched, and it means that the text that cells should begin with “excel”.”*” character is a wildcard that matching any number of characters.

Now Let’s see how this formula works:

The COUNTIF function can be used to count the number of cells in a selected range that begin with a certain pattern. And the asterisk character is a wildcard in Excel that indicates that matching any number of characters in cells. Then it returns a number that matching the given pattern.

If you want to counts the number of cells in a specified range of cells that end with a certain text(“excel”), and you can also use the CONNTIF function to create a similar formula with the pattern “*excel”as the criteria. The formula is like below:

=COUNTIF(A1:A6,”*excel”) ### 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

If Cell is This Value or That Value

IF function is frequently used in Excel worksheet to return you expect “true value” or “false value” based on the result of logical test. If you want to see if a cell is A or B, and if one of ...

If Value is Greater Than A Certain Value

IF function is frequently used in Excel worksheet to return you expect “true value” or “false value” based on the logical test result. If you want to see if a value in one cell is greater than a specific value, ...

If Cell is Not Blank

IF function is frequently used in Excel worksheet to return you expect “true value” or “false value” based on the result of created logical test. If you want to see if a cell is blank or not, and leave some ...

If Cell is Blank

IF function is frequently used in Excel worksheet to return you expect “true value” or “false value” based on the result of created logical test. If you want to see if a cell is blank or not, and leave some ...

If Cell Equals Certain Text String

IF function is frequently used in Excel worksheet to return you expect “true value” or “false value” based on the result of created logical test. If you want to see if cell equals a certain text string like “Win”, you ...

If Cell Contains Either Text1 or Text2

IF function is frequently used in Excel worksheet to return “true value” or “false value” based on the logical test result. If you want to see if cell contains certain substring1 like “abc” or substring2 like “def”, and returns true ...

If Cell Contains Certain Text OR Equals Certain Text

IF cell equals certain text IF function is frequently used in Excel worksheet to return “true value” or “false value” based on the logical test result. If you want to test values to see if they equal certain text like ...

VLOOKUP From Another Sheet Not Working

In the previous post, you should know that how to fix or remove the #N/A error when using VLOOKUP formula to lookup value from another sheet. And this post will show you reasons why your VLOOKUP formula is not working ...

If Cell Begins with One of Three Supplied Characters

If you want to test values to see if they begin with some given specific characters like “x”, ”y”, or “z”, you can create a formula with COUNTIF and SUM functions to return results. EXAMPLE You can see “TRUE” or ...

Fix #N/A Error For VLOOKUP From Another Sheet

This post will show you how to fix the #N/A error why it occurs when you extract values from another sheet using VLOOKUP function in Excel 2016,2013,2010 or other Excel versions. How can you correct a #N/A error in VLOOKUP ...

Sidebar