Finally, warp the COUNTIF formula in the SUM function. It is necessary because COUNTIF will return 3 individual counts for "apples", "bananas" and "lemons", and you need to add those counts together. Our complete formula goes as follows: =SUM(COUNTIF(A2:A10,{"apples","bananas","lemons...