賠率倍數與賠金額 計算 (13869)

E2=IF(C2=H$2,SUM(D:D)*(1-H$6*0.1)*D2/SUMIF(C:C,H$2,D:D),"")

F2=SUM(D:D)*(1-H$6*0.1)*D2/SUMIF(C:C,C2,D:D)/D2

E2另解 :先算F2後 =IF(C2=H$2,F2*D2,"")