各型號 總數量 (12557)

E2=SUMPRODUCT(ISNUMBER(FIND(D2,B$2:B$9))*MID(B$2:B$9,FIND("*",B$2:B$9)+1,9))

另解{=SUM(IFERROR(SUBSTITUTE(B$2:B$9,D2&"*",)*1,))

另解=SUMPRODUCT((0&TEXT(SUBSTITUTE(B$2:B$9,D2&"*",),"0;;;"))*1)