Point Scoring based on Rank/Placement

For ranking disqualified players as if they competed but scored zero then you could use this formula in D4 copied down

=COUNTIF(B$4:B$19,"<"&B4)+(COUNTIF(B$4:B$19,B4)+1)/2

That will always give you a total of 136 no matter what the scores

I'm not sure what you expect the scores to be if you don't award points for disqualified players - assuming that 1st should still get 16 then try this version for D30 copied down

=IF(B30="",0,COUNTA(A$30:A$45)-COUNTIF(B$30:B$45,">"&B30)-(COUNTIF(B$30:B$45,B30)-1)/2)

In your example the total would be 133 because 2 are disqualified so the 3 points for 15th and 16th places aren't awarded. The more players disqualified the less total points awarded......but 1st would always be 16 (assuming no tie), 2nd 15 etc.

Originally Posted by daddylonglegs

For ranking disqualified players as if they competed but scored zero then you could use this formula in D4 copied down

=COUNTIF(B$4:B$19,"<"&B4)+(COUNTIF(B$4:B$19,B4)+1)/2

That will always give you a total of 136 no matter what the scores

I'm not sure what you expect the scores to be if you don't award points for disqualified players - assuming that 1st should still get 16 then try this version for D30 copied down

=IF(B30="",0,COUNTA(A$30:A$45)-COUNTIF(B$30:B$45,">"&B30)-(COUNTIF(B$30:B$45,B30)-1)/2)

In your example the total would be 133 because 2 are disqualified so the 3 points for 15th and 16th places aren't awarded. The more players disqualified the less total points awarded......but 1st would always be 16 (assuming no tie), 2nd 15 etc.

Thanks, daddylonglegs.

The formulas you provided seemed to work great for column D, but it's not working out too well for me when I try and use it in timed events. Since the Rank column isn't the same as the place a competitor earned, I couldn't just reference the Rank column instead of the Data column which has times instead of whole numbers. I may just be modifying the formula wrong. :/

What you did with disqualified players resulting in fewer total points being awarded (133) works.

Thank you for your speedy response!

OK, yes, instead of the scores you could just use the ranks, perhaps that would be simpler, i.e. this version in D4

=COUNTIF(C$4:C$19,">"&C4)+(COUNTIF(C$4:C$19,C4)+1)/2