Forum Discussion
Using average
I keep a golf spread sheet that has all the points of each round. For handicapping purposes, we use the average of the last six scores. Since not every player plays each week, the six scores needed...
Thanks for your response.
I will continue to manually count the last 6 cells with scores and use the AVERAGE range of cells
scott8111 , but why manually? Did you note the formula solution given by SergeiBaklan ?
that is a direct formula , refer to attachment in his post.
(My post also had an attachment which did automation but that was a lenthy way , the formula method of other reply post is direct way.. pls note and try that and if facing any difficulty then feel free to post)