統計 主客场胜 平手 (10818)

I5:L24=SUMPRODUCT((OFFSET($B$1:$B$30,,MAX(MOD(COLUMN(B1),2)*2))=$H5)*(LOOKUP(COLUMN(A1),{1,2,3})-TEXT(LEFT($C$1:$C$30)-RIGHT($C$1:$C$30),"1;2;3")=0))

I J列{=SUM((SIGN(SUBSTITUTE("0 1"&$C$1:$C$30,"-","/1")-1)=-1^COLUMN(B1))*($B$1:$D$30=$H5)*({2,3,4}=COLUMN(A1)*2))