總和 所有字母依出現別 (12945)

E2:E3=SUMPRODUCT((COUNTIF(OFFSET(B$2,,,ROW($1:$15)),B$2:B$16)=COUNTIF(B:B,B$2:B$16)^(E2=E$3))*C$2:C$16)