Sum if Cells Contains Specific Text

An Excel file that teaches how to perform Sum if Cells Contains Specific Text operation.

Excel Dashboard for Sum If Cells Contains Specific Text

Content control is done with the SEARCH function. Condition arrays are used in SUMPRODUCT. The numbers in the rows that meet the criteria are added. The solution is used in text-oriented reporting.

Hope it is useful.