COUNTIF

Login to save your progress and get your certificate. Your course progress is only saved when you are logged in.

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.

Want to save your place in this course? Login or register to save progress and work toward your certificate.