多區數據 不重複取出後計總和 (14466)

J2{=INDIRECT(TEXT(MIN(IF((COUNTIF(J$1:J1,A$2:G$11)=0)*(A$2:G$11>0)*(A$1:G$1=A$1),ROW($2:$11)/1%+COLUMN(A:G),9999)),"!R0C00"),)&""

K2=IF(J2="","",SUMIF(A:G,J2,B:H))

Q2{=INDEX(N:N,MIN(IF((COUNTIF(Q$1:Q1,N$2:N$16)=0)*(N$2:N$16>0),ROW($2:$16),99)))&""

R2=IF(Q2="","",SUMIF(N:N,Q2,O:O))