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.
Go to Next Topic
Course Topic Navigation
Complete all topics and questions to move to the next lesson.