勝 負 平 統計各隊數 (15126)

G2{=SUM(N(IF(B$2:B$8>C$2:C$8,A$2:A$8,IF(B$2:B$8<C$2:C$8,D$2:D$8))=F2))

H2{=SUM(N(IF(B$2:B$8>C$2:C$8,D$2:D$8,IF(B$2:B$8<C$2:C$8,A$2:A$8))=F2))

I2{=COUNT(FIND(F2,IF(B$2:B$8-C$2:C$8=0,A$2:A$8&D$2:D$8)))

另解G2=SUMPRODUCT((A$2:A$8=F2)*(B$2:B$8>C$2:C$8)+(D$2:D$8=F2)*(C$2:C$8>B$2:B$8))

另解H2=SUMPRODUCT((A$2:A$8=F2)*(B$2:B$8<C$2:C$8)+(D$2:D$8=F2)*(C$2:C$8<B$2:B$8))