Table of Contents
Excel is a powerful tool that can help you automate mundane tasks, streamline complex data analysis, and organize complex information. One of the most useful features of Excel is the ability to use COUNTIF Partial Text Match to quickly and accurately count the number of cells containing a certain text. This is invaluable for quickly analyzing large data sets and making decisions based on the results. COUNTIF Partial Text Match can be used to count the number of cells with a partial text match, which can help you identify trends and patterns in large data sets. With this powerful tool, you can take your data analysis and decision-making to the next level.
You can use the following formula in Excel to count the number of cells in a range that contain a partial text match:
=COUNTIF(B2:B13, "*Gua*")
This particular formula counts the number of cells in the range B2:B13 that contain the partial text “Gua” anywhere in the cell.
Note: The * symbol is used as a wildcard operator and tells Excel that any characters can come before or after “Gua” in the cell.
The following example shows how to use this formula in practice.
Example: How to Use COUNTIF Partial Text Match in Excel
Suppose we have the following dataset that contains information about various basketball players:
Suppose we would like to count the total number of cells in the Position column that contain the partial text “Gua” anywhere in the cell.
We can type the following formula into cell D2 to do so:
=COUNTIF(B2:B13, "*Gua*")
The following screenshot shows how to use this formula in practice:
From the output we can see that there are 6 cells that contain the partial text “Gua” in the Position column.
We can verify this is correct by manually identifying each of the 6 cells that contain “Gua” somewhere in the cell:
Each of the highlighted cells contains “Gua” in the position name.