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.
In this tutorial, we will learn to write this formula by using SUMIF.
Formula to Sum IF Cell Contains a Specific Text
- First, in cell C1, enter “=SUMIF(“.
- After that, refer to the range from which we need to check the criteria.
- Now, in the criteria, enter an asterisk-criteria-asterisk (“*”&”Mobile”&”*”).
- Next, in the sum_range argument, refer to the quantity column.
- In the end, hit enter to get the result.
=SUMIF(A2:A10,”*”&”Mobile”&”*”,B2:B10)
Get the Excel File
Related Formulas
- Sum Greater than Values using SUMIF
- Sum Not Equal Values (SUMIFS) in Excel
- SUMIF / SUMIFS with an OR Logic in Excel
- SUMIF with Wildcard Characters in Excel
- SUMIFS Date Range (Sum Values Between Two Dates Array)
- Combine VLOOKUP with SUMIF
- Sum Values Based on Year (SUMIF Year)
- SUMIF By Date (Sum Values Based on a Date)
- Back to the List of Excel Formulas