Hi guys,

I tried several ways to tackle my problem but none of them seem to work... I hope some of you can help!

I have an attached example sheet which shows values in Column A; these values can be unique or the same.
I have found a working formula to count how many unique values the range in Column A has. For this I use;

=SUM(IF(FREQUENCY(Orders!A10:A157,Orders!A10:A157)>0,1))
which does the job just fine.

Now I would like the formula to check if there is a 1 present in Column G(CountOrders).
If this criteria is not met, I would like the formula to filter this out and not add the unique value in Column A(CostumerNR) to the total count.

How would I manage to do so?

Thanks in advanced for your help!

Greets

Example.xlsx