COUNTIF

Track Your Course Progress
You are currently studying as a guest. Your course progress and quiz results will not be saved unless you login to your EduCourse account. Login to track your progress and qualify for your certificate.

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.