總數 數字出現 條件Y (11468)

B2=SUMPRODUCT(ISNUMBER(FIND(","&E$2:E$10&",",","&A2&","))*(F$2:F$10="Y"))



留言