Yogi Anand, D.Eng, P.E. Google Spreadsheet Post #536 May 12, 2012 www.energyefficientbuild.com.
user golfdiscaverage said:
finding an average of last 3 non zero entries
A5 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
user golfdiscaverage said:
finding an average of last 3 non zero entries
A5 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
