Awarding Points In Standingss

I want to have the column for "Points" in my sheet to provide .5 results for ties, instead of repeating the same number and then have the next points, based on scores, to drop in places and return a whole number. If the awarded points are for 28 places based on 28 scores, I want the ties to be totaled and return a .5 result.

Abbreviating the rows, I'll use 6 places as an example. The sum of the points in the first example total 21. The sum in Example 2 total 20. The sum in example 3 total 21. I want my points to be like example 3.

Please Login or Register  to view this content.

Because there are other factors determining the standings, a simple RANK formula doesn't work.

The following formula is what I am currently using that returns results like in EX 2. Is there a simple "add on" that I can incorporate into this formula?

=IF(C4="G","",SUMPRODUCT((C$4:C$31<>"G")*(AH$4:AH$31<AH4))+1

One way:

Please Login or Register  to view this content.

It's really helpful if you post examples representative of your actual data ...

Try

=IF(C4="G","",SUMPRODUCT((C$4:C$31<>"G")+0,(AH$4:AH$31<AH4)+(AH$4:AH$31=AH4)/2)+0.5)

OK try adding a COUNTIf like this

=IF(C4="G","",SUMPRODUCT((C$4:C$31<>"G")+0,(AH$4:AH$31<AH4)+(AH$4:AH$31=AH4)/2)+0.5+COUNTIF(C$4:C$31,"G"))