總和 依字母出現次序 (13510)

D2=SUMPRODUCT((MATCH(A2:A99&"",A:A&"",)=ROW(2:99))*B2:B99)

E2=SUMPRODUCT(N(COUNTIF(A:A,A2:A99)=COUNTIF(OFFSET(A2,,,ROW(1:98)),A2:A99))*B2:B99)