Sum IF Cell Contains a Specific Text (SUMIF Partial 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
Excel SUMIF Text: Formula Examples | Coupler. io Blog To use SUMIF with text criteria, you can use the following general formula: Where: criteria_range: The range of cells that contains the criteria "text_criteria": Text criteria, enclosed in double quotes [sum_range]: The range of cells to add This parameter is optional