Hi Guys,

I need help in generating excel formula to find out count if column has values that starts with certain texts.
I know I can do it using 
=COUNTIF(B2:B13,"Lemonade") + COUNTIF(B2:B13,"*juice") + COUNTIF(B2:B13,"Ice cream")
but there are other conditions as well along with this condition.

please find attached sample file with data.

Appreciate your help.
Book1.xlsx