Hi,
New user here....wonder if anyone can help me!
I have created a spreadsheet to help calculate some results of a sports match then tabulate the players performances. Below is an example of the data:
"Player 1" 4 "Player 2" 1
"Player 2" 3 "Player 1" 2
"Player 3" 1 "Player 4" 4
"Player 4" 3 "Player 1" 2
I have used the SUMIF function to calculate the "for" figure for each player but am struggling with calcluating the "against" figure. How do I get it to add together the values of the other players?
So, if I highlight the whole range and sumif "Player 1" it totals the number of games won by each player. But how do I get it to add up the values against Player 1?
Any help appreciated!!
Bookmarks