my uncle ate potatos. potato was his favorite food. Don't mash the potato, just keep it simple.

potato

=SUMPRODUCT((LEN(A2)-LEN(SUBSTITUTE(A2;B2;"")))/LEN(B2))

3

=LEN(C1:C6)

={1;2;1;0;3;0}

=LEN(SUBSTITUTE(A1,B1&C1:C6,""))

=SUM(LEN(SUBSTITUTE(A1,B1&C1:C6,"")))

=LEN(A1)-SUM(LEN(SUBSTITUTE(A1,B1&C1:C6,"")))

=LEN(A1)*6-SUM(LEN(SUBSTITUTE(A1,B1&C1:C6,"")))

=(LEN(A1)*6-SUM(LEN(SUBSTITUTE(A1,B1&C1:C6,""))))/(LEN(B1)+1)

=IF(RIGHT(A1,LEN(B1))=B1,1,0)

=(LEN(A1)*6-SUM(LEN(SUBSTITUTE(A1,B1&C1:C6,""))))/(LEN(B1)+1)+IF(RIGHT(A1,LEN(B1))=B1,1,0)

=(LEN(A1)*6-SUM(LEN(SUBSTITUTE(A1,B1&{",",".",";"," ","/","-"},""))))/(LEN(B1)+1)+IF(RIGHT(A1,LEN(B1))=B1,1,0)