This post has been de-listed
It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.
Hello,
I'm trying to create a formula that will take the previous 3 corresponding dates (given a current date) and average the price on those dates. Typically, I could use some form of AVERAGEIF(s) function to pull this off. However, some dates prior to the selected date do not have data and thus force a #DIV/0 error. I've also tried a few variations of SUMPRODUCT functions to no avail. If anyone has any insight into how this can be accomplished within a table please share your thoughts.
- Note: I know I can do this in a pivot table but need it to be a working function inside a table for ease of updating.
SIMPLE EXAMPLE BELOW
Post Details
- Posted
- 2 years ago
- Reddit URL
- View post on reddit.com
- External URL
- reddit.com/r/excel/comme...