Trying to rank a list of scores this way. So it will show the ties.
Then I need to add the top 4 and sum together.
number ranking
2 1
3 2
3 2
5 3
6 4
so on
First problem However using the rank formula does not give this result I've
tried
something like this
=SUM(INDEX(LARGE(F6:F29,ROW(1:4)),0))

this gives me
number rank
2 1
3 2
3 3
5 4
6 5

Then not sure how to grab tthe top four I tried