I need to calculate the average of that last 20 values that aren't a ".". Since the number of "." in the range can change as the data is updated, the formula need to be dynamic as it may need to evaluate over just 20 rows if there are no "." or more rows if there are.
Here is a sample in Sheets (Since I'm not allowed to post links yet, I'm putting the Sheet link in quotes): "docs.google.com/spreadsheets/d/15ywYQSkNqMD8mUMY4iTduN32yxImxWBKhTSamQ2c6fE/edit?usp=sharing"
Feel free to edit.
No helper cells.
Thank you!
Bookmarks