I am tracking a percentage over time, adding a new column every week. I'd like to track the most recent six percentages as an average.
When I add a new column, even a cell reference locked with a $ changes.
For other numbers, ones that are not percentages, I'm successfully using INDIRECT. But for percentages, I'm getting an error message saying it's trying to divide by zero.
I've played around with OFFSET but haven't had luck there either.
I want this:
...but where the I doesn't become a J when I add a new column into D.
I tried this:
...which works for other kinds of number formats, but not percentages.
Any help would be appreciated :)