SUMIF

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.

If the corresponding cells in the range A1:A5 contain an exact circle + 1 character, the SUMIF function below sums values in the range B1:B5.

Explanation: the question mark (?) refers to exactly one character.