Function 6 – 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.

6. SUMIF

The SUMIF function below sums values in the range B1:B5 if the corresponding cells in the range A1:A5 contain exactly circle + 1 character.

Explanation: a question mark (?) matches exactly one character. Visit our page about the SUMIF function for more information and examples.