傭金以整年 累計差價計算 (14767)

D2{=SUM(TEXT(SUM(C$2:C2*(YEAR(A$2:A2)=YEAR(A2))*(B$2:B2=B2))-{0,1,2}/1%%,"0;!0;0")*{5,5,5}%)-SUM(IFERROR(D$1:D1*(YEAR(A$1:A1)=YEAR(A2))*(B$1:B1=B2),))