Thread: Combining Results Like

Hi

Attached is a spreadsheet for recording darts practice results against different practice partners. It should be pretty self explanatory what I need help with.

I want the table on the right to just be a list of all the players names (A, B, C, D) etc.
I want the table on the right to list the all time results. So if the left table say on day x i won 8 and lost 4 against player A, then on day y, I won 3 and lost 6 to the same player, the right table should say that i have won 11 and lost 10 overall.

I thought i could do it using match() with a nested index() but the match will only find the first instance of each players names in the array.

Forgot to attach here it is

Why didn't you try SUMIF?

J3=SUMIF($B$3:$B$7,$H3,D$3:D$7)

Copy down and across