Hello all,
In the attached sample, I am hoping to create a formula in cell O3 that will allow me to find the average sales for the most recent "X" number of weeks (noted in cell O1), in each store's row of data, where sales were not blank, not negative (returns), and not zero.
Hopefully this was a good explanation but basically trying to find by row, an average of the a dynamic number of weeks of sales that were not blank, and positive.
Thanks in advance
Bookmarks