With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.

Friday, May 11, 2012

yogi_Find Average Of Last Specified Number Of Entries In A Column

user golfdiscaverage said:finding an average of last 3 non zero entriesA5 to A41 are dates. B5 to B41 will be scores for those dates, but some dates haven't came up yet. I need a formula to find the last 3 non zero entries from B5 to B41. I will be adding entries as the year goes on, and I would like to have a cell (B2) that would update accordingly. Some weeks there won't be an entry due to a no show, and I need my formula to skip that week or put 0, but to average the last 3 non zero's. Thanks for any help.---------------------------------------------------------following is a solution to the problem where I have generalized the number of last non-zero entries to be entertained