Thread: Row count, for multiple criteria, with string search.

Problem: I need to count rows where col1 has "Cow" and col2 has "Milk" (in the spreadsheet below)
I am have written this formula, but the result is inaccurate (expected=3, actual=1).

=SUMPRODUCT(('Sheet 1'!B2:B300="Cow")*('Sheet 1'!G2:G300="Milk"))

Sample spreadsheet:

Cow Milk
Calf Cheese
Cow and Calf Milk, Cheese
Calf Cheese, Milk
Cow and Calf Milk


It looks like the exact word is matched. I've tried adding the wild character *, like "Cow*", but it doesn't work. What's missing here?? (I am not an excel programmer ) )