How to Countif with Partial Match

In this Excel tutorial you will learn how to countif cells with partial match in Excel. The efficiency of using the countif partial text is its contribution to a productive end-result. 

Data preparation

This is a function that starts with having a data like this:

partial countif data table

Countif formula

To count cells that contain a partial match in Microsoft Excel, you can use the COUNTIF function with the wildcard character "*". Here's how:

Click on an empty cell (1), and then type in the =COUNTIF(B$2:B$6,"*TL*") to find the numbers of TL.

countif formula grep string

The result will be the number of cells in the specified range that contain the partial match.

Note: This allows the ability to count the numbers of TL that are in the column b, and this is traditionally determined by the user, so it is up to the user to decide what he or she wants to look for.

This is how countif with approximate match is being done in Excel.