加總 序号逗點前數字 (11117)

D2{=INDEX(A:A,SMALL(IF(ISERR(FIND(".",A$2:A$16)),ROW($2:$16),99),ROW(A1)))&""

E2=IF(D2="","",SUMPRODUCT((LEFT(A$2:A$16,FIND(".",A$2:A$16&".")-1)-D2=0)*B$2:B$16))

另解=IF(D2="","",SUMPRODUCT((1-ISERR(FIND(0&D2&".",0&A$2:A$16&".")))*B$2:B$16))