Hello, I am trying to add all orders that are done on the same month and then divide it the number of days in order to calculate the average demand rate. My problem is that I can not design an if statement or sum, or whatever it should be that reads the date and then if the date is correct it adds the item 1 ordered.
Here is the file.HW2.xlsx