同單位 加總 (15207)

F2:F4=SUMPRODUCT(ISNUMBER(FIND(E2,B$2:B$9))*LEFT(B$2:B$9,FIND(" ",B$2:B$9)))

(數字與單位無須空白格)G2:G4{=SUM(IFERROR(SUBSTITUTE(B$2:B$9,E2,)*1,))