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.
Get the Excel File
DownloadFormula 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
DownloadMore
- 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)
- SUMIF Non-Blank (Sum Values for Non-Empty Cells)
- Use SUMIF to Sum Blank Values or Empty Cells
- Sum Values Less Than a Particular Value (SUMIF Less Than)
- Sum Values that are Greater Than Zero (SUMIF)
- Sum Values Based on the Month (SUMIF)
⇠ Back to Top Excel Formulas List