How to use the SUMIFS function to calculate on the condition of "Containing a specific string".(Microsoft Excel)

Japanese version.

Here we will show you how to use the SUMIFS function to perform aggregation under the "contains a specific string" condition.
The SUMIF function can be used in the same way.

Steps

Use a feature called wildcards in the conditions.

Contains

Place "*" before and after the search criteria.

In the formula below, the condition is "contains o".

=SUMIFS(C4:C10,B4:B10,"*o*")

Start with

Place "*" after the search criteria.

In the formula below, the condition is that it starts with "ca".

=SUMIFS(C4:C10,B4:B10,"ca*")

End with

Place "*" before the search criteria.

In the formula below, the condition is that it ends with "e".

=SUMIFS(C4:C10,B4:B10,"*e")

---

Links

Tips. Others.(Microsoft Excel)