Function 6 – SUMIF

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.