總和 依前 後二字母 (11047)

F2=SUMPRODUCT((FIND(E2,B$2:B$21&E2)=1)*C$2:C$21)

I2=SUMPRODUCT((FIND(H2,MID(B$2:B$21,2,9)&H2)=1)*C$2:C$21)