Sum if ends with

To sum numbers when corresponding text values end with specific text, you can use the SUMIFS function or the SUMIF function. In the example shown, the formula in F5 is: =SUMIFS(C5:C16,B5:B16,"*small") The result is 19, which is the sum of the quantities in the range C5:C16 when the corresponding item names in B5:B16 end with "small". Note the SUMIFS function is not case-sensitive.

April 14, 2025 · 1 min · 65 words · Elizabeth Miller

Table of Contents

Wildcards

Certain Excel functions like SUMIFS and SUMIF support thewildcardcharacters “?”

Notice both the text and the wildcard must be enclosed in double quotes ("").

Also note that SUMIFS isnotcase-sensitive.

Excel formula: Sum if begins with

The generic syntax for theSUMIF functionlooks like this:

Noticesum_rangecomeslastin the SUMIF function.

Criteria can be applied to dates, numbers, and text.

How to use the SUMIF function

How to use the SUMIFS function

Excel formula: Sum if cells contain specific text

Excel formula: Sum if not blank

Excel formula: Sum if cells are not equal to

Excel formula: Sum if x or y

Excel SUMIF function

Excel SUMIFS function