basically to split between ties we need to find the average of the prize money, which is the total prize money divided by the number of people with the same score
Code:
=SUMIF($C$2:$C$10,C2,$F$2:$F$10)/COUNTIF($C$2:$C$10,C2)
to find the total prize money of people with the same score we use SUMIF
SUMIF adds numbers together based on various criteria
SUMIF(range of cells your are checking, criteria you are checking for, range of numbers to sum)
the range we are looking at is all the possible places in $C$2 to the bottom (now that i think about it, you might be able to just use the whole of column C as a reference instead of specifying C2 to whatever if you want to simplify the code a bit). the criteria we are looking for is the place that specific player got in C2. and the range of numbers sum adds the numbers that fulfill the criteria
basically it looks at what place the player got and adds all the prize money amounts that have the same place
COUNTIF gives us the number of players with the same place
COUNTIF(range you're looking in, what you're looking for)
this gives you a count of all the occurrences of the value you're looking for, in this case the player's place, in the range
sorry it's not the best explanation. i'm not great with words. the office support site have better explanations and examples
https://support.office.com/en-us/article/sumif-function-169b8c99-c05c-4483-a712-1697a653039b
https://support.office.com/en-us/article/COUNTIF-function-E0DE10C6-F885-4E71-ABB4-1F464816DF34
