Hey Guys

I have a Log that goes from E6:E200 for the day and i want to count how many times a string occurs, I have been using sumproduct but
people cant type or use the right grammer

Having Problems i thought i had it figured out with this
=SUM(LEN(E6:E200)-LEN(SUBSTITUTE(E6:E200,"Shop 1","")))/LEN("Shop 1")
But gets errors and when it does work wont count Multibles

the 4 Strings are Shop 1, Shop 2, Shop 3, & Shop 4 these can be used all at once also so say Shane goes to Shop 1 & 2 then Bill goes to
Shop 3 & 4 and then Kim Goes to Shop 2, 3 & 4