Maybe, you can add "x" in A37:A40 for the teams you want to count in...
and then change formulas in C42 and D42 to:
=SUMPRODUCT(--($J$5:$J$26=B42),--(ISNUMBER(MATCH($M$5:$M$26,IF($A$37:$A$40="x",$B$37:$B$40),0))),--($K$5:$K$26>$L$5:$L$26))+SUMPRODUCT(--(ISNUMBER(MATCH($J$5:$J$26,IF($A$37:$A$40="x",$B$37:$B$40),0))),--($M$5:$M$26=B42),--($L$5:$L$26>$K$5:$K$26))
and
=SUMPRODUCT(--($J$5:$J$26=B42),--(ISNUMBER(MATCH($M$5:$M$26,IF($A$37:$A$40="x",$B$37:$B$40),0))),--($K$5:$K$26>$L$5:$L$26))+SUMPRODUCT(--(ISNUMBER(MATCH($J$5:$J$26,IF($A$37:$A$40="x",$B$37:$B$40),0))),--($M$5:$M$26=B42),--($L$5:$L$26>$K$5:$K$26))
each of these formulas need to be confirmed with CTRL+SHIFT+ENTER not just ENTER to work.
Now you just put an "x" beside the team(s) in B37:B40 that you want to count in the wins/losses.
Will that work for you?
Bookmarks