多維取不重複後 計總金额 (14118)

取不重複R2{=IFERROR(INDIRECT(TEXT(SMALL(IF((COUNTIF(R$1:R1,B$2:L$9)=0)*(MOD(COLUMN(B:L),5)=2),ROW($2:$9)/1%+COLUMN(B:L)),1),"!R0C00"),),"")

S2=IF(R2="","",SUMIF(B:L,R2,F:P))