Calculate average of last 10 cells in a row that have a value, skipping blanks

I am working with a dataset involving golfers' scores, arranged with each golfer's name in column A and the associated scores in columns B-AG of each row. I will be continuously adding data to columns to the far right (as I have more scores). I want to calculate the average of the last 10 scores (cells), but only including cells that have a value, meaning the formula will need to skip cells that are blank.

I'm attaching a workbook with the dataset.

Any suggestions would be much appreciated!

Thanks!

To clarify, I need to calculate the average of the last 10 scores for each person, regardless of how many cells that would take. Meaning for some it might be the last 10 columns, but some may have blanks and therefore require an average of the last 15 cells (if 5 are blank) to determine the average of the last 10 scores/cells that have a value. So it is not merely the average of the last 10, but the last 10 excluding blanks.


Thanks!