加總 區別相似姓名 (14630)

F2=SUMPRODUCT(ISNUMBER(FIND(","&E2&",",","&A$2:A$8&","))*B$2:B$8)



留言