汇总 五項條件 (10866)

P2=SUMPRODUCT((MMULT(N(B$2:D$9=K2:M2),{1;1;1})+(G$2:G$9=N2)=4)*E$2:E$9/(LEN(H$2:H$9)+1-LEN(SUBSTITUTE(H$2:H$9,",",))))