Berry Metzger
asked on
Rolling Average using a variable
Hello Experts,
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,
Berry
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,
Berry
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're welcome.
ASKER
Berry