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??