Problem:

Each row of columns A & B contains text and a corresponding number.

We want to sum all the numbers in column B corresponding with the text values in column A that meet the following criteria:

1. Text is “Excel”.

2. Text starts with “Excel”.

3. Text ends with “Excel”.

4. Text contains “Excel”.

5. Text length is 3 characters.

Solution:

Use the SUMIF function as shown in the following formulas:

1. =SUMIF(A2:A7,”Excel”,B2:B7)

2. =SUMIF(A2:A7,”Excel*”,B2:B7)

3. =SUMIF(A2:A7,”*Excel”,B2:B7)

4. =SUMIF(A2:A7,”*Excel*”,B2:B7)

5. =SUMIF(A2:A7,”???”,B2:B7)