I have weekly sales data for a particular product. In the promotions tab if there is a 1 it means it is on promotion for that week. If the cell is blank then it wasn’t on promotion. In the promotions tab column AO I want to get the average sales for when it is on promotion.
How do I get excel to identify the 1, when it is on promotion, and then average the sales of these weeks. I have multiple rows of data with common reference numbers.
Bookmarks