Golf

I would further suggest the sheet set up is probably not optimal.

I would suggest 1 sheet/table to have data entry like golfer, score and maybe some other info might be helpful like date, course, weather, ???

Then another sheet could have the summary information like:

List of golfers can be:

UNIQUE( [golfer name column] )

then you can have a list of the top 10 scores be:

=TRANSPOSE( TAKE( SORT( FILTER( [scores], [golfer] = golfer name ) ), 10))

and then the average of the top 4 is simply something like =AVERAGE(B2:E2)

Some of the formulas could be made more versatile (automatically spill) but in concept see the attached