Tennis Ranking

Have a platform tennis league with individual ranking but in doubles play and am trying to create a macro, rule or link from a series of cells.

attached shows ranking workbook with players 1-10. In colums to right of player number, I want to talley the matches won, lost and games won lost from the colums of matches workbook.

Example, cell B3 in Rankings workbook =SUM of column B of matches workbook IF A=1.

ANY THOUGHTS??

In B2, try:

=SUMIF(matches!$A:$A,$A2,matches!B:B)

copied down and across the columns