How to countif cells with partial match?

The efficiency of using the countif partial text is its contribution to a productive end-result. This is a function that starts with having a data like this:

data table

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

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.