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 ) )
Bookmarks