» Counting the number of cells containing a substring

CATEGORY - Excel Formula and Function VERSION - All Microsoft Excel Versions

Problem:
Count number of cells containing certain substring.

Solution:
To find the number of cells in a range containing the substring ""Excel"",
use the following formula:
=COUNTIF(A2:A4,""*Excel*"")

Example:
Microsoft Excel 2003
Microsoft Outlook 2003
Microsoft Excel 2000

Result 2
Formula =COUNTIF(A2:A4,"*Excel*")
Screenshot // Counting the number of cells containing a substring