Hello Experts. I need your help again.
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). Now I want to count the quantity of unique entries within each delivery (see column H).
I also need help summing the quantity of pieces for only those unique entries (see column X).
Can you give me a hand?