Group scores based on value in first column

For the first SUMPRODUCT, I used it to calculate the number of time a player participated in a tournament, for example, this is the one in Cell C18

SUMPRODUCT(--($A$4:$A$11&$B$4:$H$11=C$17&$A18))

What it does is combine value in A4 to A11 with B4 to H11 and create an array of player + tournament name (for e.g "AnnaTournament 1", "BertTournament 2", and so on), then compare it with the player name and tournament you are checking (on Cell C18, it's "AnnaTournament 1"). The "--" added in front of it makes the logic statement return 1 or 0 instead of TRUE or FALSE, thus making them sum-able. If this SUMPRODUCT returns 0, obviously Anna does not participated in Tournament 1, right?

With the same idea, I used the second SUMPRODUCT to calculate the point

SUMPRODUCT(--($A$4:$A$11&$B$4:$H$11=C$17&$A18),$C$4:$I$11))

It's basically the same, with the added reference from C4 to I11, is where the points are. When the reference of player combined with a tournament name is found on a specific row / column, it will return the corresponding value of points in the same row but in the column next to it (that's why for the first part of the Cell Reference is from B4 to H11, but the later part is C4 to I11. Also, this is why I keep the habit of adding extra column to keep the reference match).

I'm sorry if I have confused you because I am not that good with explanation. What you can always do is to copy straight one of the SUMPRODUCT on the formula, paste it else where to see what it's doing, and try changing the reference.