二項相同 進出統計起止數 (12913)

M2=IFERROR(LOOKUP(1,0/(I$1:I1=I2)/(J$1:J1=J2),N$1:N1),K2)

N2=SUMPRODUCT((I$2:I2=I2)*(J$2:J2=J2)*(K$2:K2-L$2:L2))