SUMIF

Complete Lessons and Earn Your Certificates Now

10. Most Used Functions Data Entry – Introduction Course
Back to Course Back to Lesson

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.