A B C D Pork Meat Bad Unhealthy Cheese Dairy Good Carrot Vegetable Good Healthy Apple Fruit Good Healthy Steak Meat Good Unhealthy Chicken Meat Good Healthy Broccoli Vegetable Bad Healthy Bacon Meat Good Unhealthy Ice cream Dairy Good Pear Fruit Good Healthy =COUNTIFS(C1:C10,"Good",B1:B10,"Dairy",D1:D10,"") 0 Wrong =SUMPRODUCT(C1:C10="Good",B1:B10="Dairy",D1:D10="") 2 Correct