加總 依序號起止 (14081)

F2=SUMPRODUCT((1-ISNA(MATCH(B$2:B$9,ROW(INDIRECT(SUBSTITUTE(E2,"-",":"))),)))*C$2:C$9)

另解=SUMPRODUCT(OFFSET(C$1,LEFT(E2,FIND("-",E2)-1),,MID(E2,FIND("-",E2)+1,9)-LEFT(E2,FIND("-",E2)-1)+1))