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.