Saturday, October 3, 2015

yogi_ComputeRolling Average Of Last Non-Blank 12 Entries In Range B4 to B

Google Spreadsheet   Post  #1979
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Oct-03-2015
post by  Far Beyond Insanity:!msg/docs/7H-fU0515zE/jb5a8TafBQAJ;context-place=topicsearchin/docs/category$3Aspreadsheets%7Csort:relevance%7Cspell:false
a rolling average question, need solution.
I am trying to get an average in a single column but cannot find any help here. All the suggestions I have found the formula errors out. I want to have this average automatically adjust to the last 12 fields that have been entered. Lets say at b1 I want the total of the last 12 fields in B. If it stats from b4 to b16 but when I add b17, b18, b19, and so on it will look at only the last 12. So when I get to b20, it is going to look at field b8 to b20 and average it. 

How do I make this happen?