多維數據彙整 (11722)

K2:K14{=IFERROR(INDIRECT(TEXT(SMALL(IF((COUNTIF(K$1:K1,B$2:H$8)=0)*(B$1:H$1=K$1)*(B$2:H$8>0),ROW($2:$8)/1%+COLUMN(B:H)),1),"!R0C00"),),"")

L2:N14=TEXT(SUMPRODUCT(($C$1:$I$1=L$1)*($B$2:$H$8=$K2)*N(+$C$2:$I$8)),"0;;")