Countifs excluding duplicates

[Publicpenguin]

Hi Everyone,

I'm trying to count the number of products we have coming in during a given timeframe. Unfortunately the data I'm receiving will often list dupilcates of the same order. I'm really hoping to bypass the tedious task of deleting the hundreds of duplicates and just run a countifs function based on the product category and its arrival date which will exclude any duplicate orders. I've attached a simple sample of what I'm hoping to do. It seems like this would be a simple and common issue to resolve, but I just can't get past it yet or find the proper solution.

Thank You Preemptively

[Tony Valko]

Can you post the file without any VBA in the *.xlsx format?

[Publicpenguin]

Sure think and sorry for that.

[azumi]

Maybe:

put this in non merged cells:

=SUM(IF(FREQUENCY(IF(A3:A14=E4,IF(B3:B14>=F4,IF(B3:B14<=H4,MATCH(B3:B14,B3:B14,0)))),ROW(A3:A14)-ROW(A3)+1),1))

Array Formula, you need to press CTRL-SHIFT-ENTER button together, ENTER alone is not work..

[Publicpenguin]

Hi Azumi,

This formula certainly returns the correct total. Incorporating it into my main workbook, I was unable to return the correct value. I think that I may have oversimplified my issue for there are several other criteria I need to check and thousands of categories that will only grow every month. My apologies to you and dev. for a post that could have been done better and thank you for responding and solving this one so quickly