I need a formula to find the average number of products sold, from data that is on multiple sheets. The products are never in the exact same sale as the sheet is sequenced by time periods of 15 minutes and the products are only listed if they are sold. (i.e. I sell 2 apples at 1pm on day 1, 3 bananas at 1pm on day 2, and 5 apples at 1pm on day 3. My averages sales over the 3 days at 1pm are 3 apples and 3 bananas.)
Solved by C. Q. in 22 mins