Hello all, great board;

I have a list of items a user can select from a list. A short version is;

Beef
Sheep
Corn
Wheat
Beats
Ovine

In one column we store the results of what they checked so we can have any combination of from the list. eg, [ Beef, Corn, Wheat ] in another row I'll have [ Corn, Sheep, Ovine ].

I would like to be able to count the rows that have Corn or Wheat or Beats in them and have that row count as 1. I would also like to count the rows that have Beef or Sheep or Ovine in the them and have them count as 1.

There's 30,000 rows and I would like to know how many have crops, and how many have livestock.

I've tried =COUNTIF(V2:V30000,"*Wheat*")+COUNTIF(V2:V30000,"*Corn*")

but I think I'm getting the row counted twice.