總和 二項不重复且正值 (11165)

D2=SUMPRODUCT((MATCH(A2:A8&B2:B8,A2:A8&B2:B8,)=ROW(1:7))*(B2:B8>0)*B2:B8)

另解=SUMPRODUCT(SUMIFS(B:B,A:A,A2:A8,B:B,B2:B8,B:B,">0")/COUNTIFS(A:A,A2:A8,B:B,B2:B8)^2)