I need help with a rolling average formula that looks at cell $D$2 for the number n to include in the average of the last [right-most] n columns containing data [or blank(s)]. The quantity of columns involved may extend from 1 to 200+ columns so the formula should be flexible to include infinite expansion to the right.
File attached with a formula that needs fixed. RollingAverage.xlsx
Thanks in advance,