(“*”& on both sides of the criteria D8 is known as wildcards)
![how to sum a column in excel with text how to sum a column in excel with text](https://support.content.office.net/en-us/media/1a57f414-aaa7-4e09-bdf8-20a5f2e35685.jpg)
Press Enter to get the total quantity of fruit.Use SUMIF formula in cell F9 with A3:A10 as range, “Fruit” as criteria instead of E9 and C3:C10 as sum_range.Write down the specific criteria in E9 and E10.Take a separate column E for the criteria and F for the total quantity.In order to add the sum range based on a specific text criteria, we need to: This is a grocery list with a range that contains specific repeated text. Let’s have a look on how is it done with a slight change in the formula Using SUMIF if cells contain specific textįormula for specific text: =SUMIF(range,”criterianame”,sum_range) With the help of SUMIF Function, we can also add cells that contain specific or partial text and even if the cells contain numbers and text altogether, they can also be added.
![how to sum a column in excel with text how to sum a column in excel with text](https://i.stack.imgur.com/i9yup.jpg)
Using the SUMIF Function to Add Cells if They Contain Certain Text