Sum IF Cell Contains a Specific Text (SUMIF Partial Text)

Last Updated: March 24, 2024
puneet-gogia-excel-champs

- Written by Puneet

To sum values from cells where you have a specific text or a partial text, you need to use wildcard characters with SUMIF. In the criteria argument, you need to use an asterisk before and after the text using an ampersand, just like we have used in the following example to sum cells where you have the text “Mobile” in the “Product” column.

sumif-partial-text

In this tutorial, we will learn to write this formula by using SUMIF.

Formula to Sum IF Cell Contains a Specific Text

  1. First, in cell C1, enter “=SUMIF(“.
  2. After that, refer to the range from which we need to check the criteria.
  3. Now, in the criteria, enter an asterisk-criteria-asterisk (“*”&”Mobile”&”*”).
  4. Next, in the sum_range argument, refer to the quantity column.
  5. In the end, hit enter to get the result.
understand-sumif-contains-text-formula

=SUMIF(A2:A10,”*”&”Mobile”&”*”,B2:B10)

sumif-reference

Get the Excel File