台彩統計歷年出現次數 (13110)

C2:C16=SUMPRODUCT(COUNTIF(M$2:R$2,D2:I2))

M6:M15{=SUM((MMULT(COUNTIF(M$2:R$2,D$2:I$999),{1;1;1;1;1;1})-LEFT(L6)=0)*IF(RIGHT(L6)-1=0,J$2:J$999=S$2,J$2:J$999<>S$2))