總和 出現起止序號 (11915)

H2=SUMPRODUCT(B$2:B$29*(COUNTIF(OFFSET(C$2,,,ROW($1:$28)),E2)>=F2)*(COUNTIF(OFFSET(C$2,,,ROW($1:$28)),E2)<=G2)*(C$2:C$29=E2))

另解{=SUM(RIGHT(SMALL(IF($C$2:$C$29=E2,ROW($2:$29)*10^8+$B$2:$B$29),ROW(INDIRECT(F2&":"&G2))),8)*1)