Countif with same criteria in multiple columns

Ah yeah I can make that work. I've amended it to if A11=Any then do that formula, else do your original formula which covers both scenarios. I also want to have the goals for and goals against columns update based on the selected position but I'm not sure I fully understand what MMULT is doing here to be able to apply it. I'll start reading up on it now but if you have a straightforward explanation for this scenario it would be really appreciated!

Originally Posted by AliGW

This?

=SUMPRODUCT(($A$2:$A$9=$A13)*($C$2:$C$9="Win")*MMULT(--($F$2:$H$9="LM"),{1;1;1}))

Apologies, it was this which seems to be in the ballpark of what I'm trying to do. I've adjusted the formula in B13 to =if($A$11="Any",SUMPRODUCT(($A$2:$A$9=$A13)*($C$2:$C$9="Win")*MMULT(--($F$2:$H$9=$B$11),{1;1;1})),SUMPRODUCT(($A$2:$A$9=$A13)*($C$2:$C$9="Win")*((FILTER($F$2:$H$9,$F$1:$H$1=$A$11)=$B$11)))) which currently works and I can amend "Win" to "Draw" and "Loss" for the other columns. I don't really understand how MMULT is working here though if you're able to clarify.

I did read through the forum rules although it doesn't mention how to reply. I'm assuming I should be using "Reply with Quote" so hope that makes it easier. Sorry, it's been forever since I've used this type of Forum! Thank you for your help