Naughty you!! You changed the attachment after posting!!

The 908/U908 issue caused some problems, for a while...

=IF($G2="","",SUMPRODUCT((($A$2:$A$6=H$1)*(LEN("¦"&SUBSTITUTE($B$2:$C$6,",","¦"))-(LEN(SUBSTITUTE("¦"&SUBSTITUTE($B$2:$C$6,",","¦"),"¦"&$G2,"")))))/LEN("¦"&$G2)))

copied across and down.