J2:J11=IFERROR(LOOKUP(1,0/(MMULT(N(A$1:D1=A2:D2),{1;1;1;1})=4),J$1:J1)&";","")&E2&F2&G2
K2:N9 {=INDEX(A:A,MIN(IF(COUNTIFS($K$1:$K1,$A$2:$A$11,$L$1:$L1,$B$2:$B$11,$M$1:$M1,$C$2:$C$11,$N$1:$N1,$D$2:$D$11)=0,ROW($2:$11),4^8)))&""
O2:O9=IFERROR(LOOKUP(1,0/(MMULT(N(K2:N2=A$2:D$11),{1;1;1;1})=4),J$2:J$11),"")
P2:P9=IF(O2="","",SUMIFS(F:F,A:A,K2,B:B,L2,C:C,M2,D:D,N2))
Q2:Q9=IF(O2="","",SUMIFS(H:H,A:A,K2,B:B,L2,C:C,M2,D:D,N2)) |