Here's the problem. I am trying to find a solution to the following problem.
I need to make a spreadsheet based on a sample of the following info.

Name
Norm 80 70 75 90 95 96 98 92 85 70
Jon 100 102 104 106 98 95 112 95 98 97

With this data, I need a formula to calculate the average of the lowest 5
scores (out of 10 total). I need cell refrences. Thanks in advance.