Hello everyone,
I have searched and searched and thought I found an answer but didn't.
I am a golf coach and want to create a formula to average my golfers last three scores. However, not every player plays in each match, so some will have their last 3 scores be in a row where others may have blank cells inbetween.
I have the data set up in rows such as this example of the last 3 matches:
Golfer 1: 72, 72, 75, 78, 77
Golfer 2: 80, , 81, , 84
Golfer 3: 76, 77, 78, , 79
Again, I want to average the last three cells in the row that have a value in them.
Any suggestions?
Much appreciated,
Coach
Bookmarks