Hello all
A B
Name code
EN A3
LL B4
EN C2
AB B3
EN,AB A3

column A values have a name of P1B and column B has values named P1F

I have the above data and Im trying to use it to count quantites of each
instance of code for each 2 letter name, e.g EN has 2 instances of code A3

Im using
=SUMPRODUCT((P1B="EN")*(P1F="B7"))

but I cant get the formula to count when there is more than one name in a
cell (eg EN,AB. I have tried using "*EN*" but doesnt work

Please help!