How To Countif Cells With Partial Match In Excel
Click on an empty cell (1), and then type in the =COUNTIF(B$2:B$6,”*TL*”) to find the numbers of TL.
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.
Template
You can download the Template here – Download
Further reading: Basic concepts Getting started with Excel Cell References
