Leader Board Scores

[[email protected]]

I need to find a fair way to select our next comp team based on the results from the previous comp. I have added all of the scores for the individual events and overall results. However I would like to select the team based on how many points each player has been awarded based on the 1st, 2nd, 3rd, etc table for each individual event. I need the "Points Column" to add up the points awarded from the table below the main spreadsheet but have no idea where to start. Any help would be greatly appreciated.

[BadlySpelledBuoy]

Could you give a couple of examples of expected results?

[[email protected]]

Wow, thanks for the rapid response.

I've attached a spreadsheet with the expected results calculated manually in the "Points" column.

[boopathiraja]

Try this

=SUMPRODUCT(--($A$13:$A$22=G2),$B$13:$B$22)+SUMPRODUCT(--($A$13:$A$22=I2),$B$13:$B$22)+SUMPRODUCT(--($A$13:$A$22=K2),$B$13:$B$22)+SUMPRODUCT(--($A$13:

[[email protected]]

Nope. That doesn't work.

I've calculated all the Points Column results manually (see attached)

[boopathiraja]

Hi, Check now with the below


=SUMPRODUCT(--($A$13:$A$22=G2),$B$13:$B$22)+SUMPRODUCT(--($A$13:$A$22=I2),$B$13:$B$22)+SUMPRODUCT(--($A$13:$A$22=K2),$B$13:$B$22)+SUMPRODUCT(--($A$13:$A$22=M2),$B$13:$B$22)

[BadlySpelledBuoy]

In P2 and copy down:

=INDEX($B$13:$B$22,MATCH(G2,$A$13:$A$22,0))+INDEX($B$13:$B$22,MATCH(I2,$A$13:$A$22,0))+INDEX($B$13:$B$22,MATCH(K2,$A$13:$A$22,0))+INDEX($B$13:$B$22,MATCH(M2,$A$13:$A$22,0))

There's probably a much better way of doing this but I don't have it right now.