Calculate Opponents Win Loss Record

Aaron played against 3 opponents so far...Kevin, Shannon and Tom.

Kevin's record to date is 0-2
Shannon's record to date is 4-1
Tom's record to date is 3-3

So in this case Aaron's opponents record is 7-6. The next time Kevin plays though his record will change, and thus Aaron's opponents record will change. We really only need this because we are not going to get all players to play all other players before we start the tournament rounds and so we are trying to weight the quality of opponent for each player. This way at the end of the preliminary rounds if we have two players that are 11-0 we can determine which player had a tougher "schedule" and thus deserves the #1 seed.

I don't have a solution for you (too late in the day) but I would like to point out (on Kevin's behalf) that his record is actually 1-2 (not 0-2). His win isn't showing up in cell H9 because there is a space after his name in cell A2.

You're welcome, Kevin.

OK, here is something for you to test.

Sorry, forgot to do the absolute referencing (I told you it was too late in the day).

Change the formula in cell N2 to this:

=SUM(SUMIF($A$2:$A$47,G2,$V$2:$V$47),SUMIF($E$2:$E$47,G2,$T$2:$T$47))

and in cell O2 to this:

=SUM(SUMIF($A$2:$A$47,G2,$W$2:$W$47),SUMIF($E$2:$E$47,G2,$U$2:$U$47))

and drag those 2 cells down to row 17 - now test it.

Thanks Cutter. You resolved the issue, and I was even able to figure out the logic behind it after reviewing it.

As for Kevin, this is actually my buddy's spreadsheet that I decided to automate for him. He must have put Kevin with a space before I put in my data validation requirements. Great catch!

You're welcome. Glad to have helped. Tell Kevin he owes me one.

Please remember to mark your thread as SOLVED (click Forum Rules @ top of page - see rule #9 for instructions).

Done. Somehow I couldn't find the solved option last night. Thanks again.