SUMIF

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.

Free Courses