統計銷售 依各人員 有相似品項 (11950)

F2:H6=SUMPRODUCT((TRIM(MID(SUBSTITUTE($B$2:$B$16,",",REPT(" ",99)),COLUMN($A:$I)*99-98,99))=$E2)*($C$2:$C$16=F$1))