不同客戶與不同貨幣細分 算總額 (14201)

E2{=INDEX(A:A,MIN(IF(COUNTIF(E$1:E1,$A$2:$A$99)=0,ROW($2:$99),99)))&""

F2=IF(E2="","",COUNTIF(A:A,E2))

不同客戶與不同貨幣細分 I2:J2 下拉{=INDEX(A:A,SMALL(IF(MATCH($A$2:$A$99&$B$2:$B$99,$A$2:$A$99&$B$2:$B$99,)=ROW($1:$98),ROW($2:$99),99),ROW(A1)))&""

K2=IF(I2="","",SUMIFS(C:C,A:A,I2,B:B,J2))

L2=IF(I2="","",VLOOKUP(J2,N:O,2,)*K2)