總和 同字母後面數字 (14172)

D2{=LEFT(INDEX(B:B,MIN(IF((COUNTIF(D$1:D1,LEFT(B$2:B$16))=0)*ISNUMBER((FIND("-",B$2:B$16))),ROW($2:$16),99))))&""

E2{=IF(D2="","",SUM(IFERROR(ISNUMBER(FIND(D2,$B$2:$B$16))*MID(B$2:B$16,3,9),)))