COUNTIF

The COUNTIF function below counts the number of cells containing an exact star + a sequence of characters, zero or more.

Explanation: an asterisk (*) fits a sequence of zero or more characters.