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.
Go to Next Topic
Course Topic Navigation
Complete all topics and questions to move to the next lesson.