Unique value count based on multiple criteria

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;

Please Login or Register  to view this content.

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

Thanks a bunch!!!

I should read up on array formulas....