Function 5 – COUNTIF

The COUNTIF function below counts the number of cells that contain exactly star + a series of zero or more characters.

Explanation: an asterisk (*) matches a series of zero or more characters. Visit our page about the  COUNTIF function for more information and examples.