二數據 各計總和 (11886)

E2:G16{=IFERROR(IF(COUNTIF($B$2:$B2,$B2)=1,INDEX(SUMIFS($D$2:$D$16,$B$2:$B$16,$B$2:$B$16,$C$2:$C$16,$C$2:$C$16),SMALL(IF(($B$2:$B$16=$B2)*(MATCH($B$2:$B$16&$C$2:$C$16,$B$2:$B$16&$C$2:$C$16,)=ROW($1:$15)),ROW($1:$15)),COLUMN(A1))),""),"")