Apply Criteria To Text Values. To indicate an equality comparison operator for either text or a value type the criteria as a string expression in the appropriate cell in the criteria range. You can use several types of criteria like text dates read about applying criteria to text and using dates as criteria and functions.
33 rows Introduction to query criteria. For example if you want to count cells that contain the alphabet a in it use a as the criteria. The criteria are Name and Product and you want them to return a Qty value in cell C18.
The Excel SUMIF function returns the sum of cells that meet a single condition.
If you just want to sum the cell values in column B where the corresponding cell in column A which text starts with KTE you can apply this formula. Because the value that you want to return is a number you can use a simple SUMPRODUCT formula to look for the Name James Atkinson and the Product Milk Pack to return the Qty. Please apply the below formulas to deal with this task. In this case lookup with several conditions is the only solution.