Hello Experts. I need your help modifying a previous solution. (Ref: http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_27018532.html
I have been using the SUM IF FREQUENCY formula with some success (see attached sample file). I need help modifying it to take into account other criteria.
I am working with a large legacy report to extract summaries. I have many duplicate entries. Using the SUM IF FREQUENCY I have been able to count the quantity of unique entries (orders & deliveries – columns E & F). You already helped me develop a formula to count the quantity of unique entries within each delivery (see I42).
Now I need to add criteria to that formula to also count when the Quantity (Col Y) changes within an Item Number.
Can you give me a hand?