Forum Discussion
Using average
scott8111 , For this type of problem, a direct formula even if it could be formed would probably be too complicated, and i at least couldn't think of one. However, i present one approach of doing it step by step like our mind tends to think, i.e. filter out the last six (non-zero) scores and then take their average. The desired calculation could be achieved as in attachment, but as you would note, it is more of a template rather than a formula. The template is expandable, but one need to be careful to expand (drag) the formulas correctly. Also, till you gain confidence of understanding and using it, i would suggest cross-checking the calculated results manually. Step by step way of calculation makes cross-checkings easy, i think!
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)