Need a formula to count unique names in a column based on criteria from another column.

Hi all,

I have a table where I need to count only values of 0 in column B and from those remaining cells remove the duplicates in column A (which is made up of numbers and letters).

As an example of what it basically looks like;

CUSTOMER | INVOICE AMOUNT
Smith0123 | 0
Cooper0123 | 123
White0123 | 165
Cooper0123 | 0
Osbourne0123 | 651
Smith0123 | 0
Osbourne0123 | 0
Smith0123 | 9
White0123 | 58169



So I would need the formula to tell me that of the 5 values of 0 in the Invoice Amounts column there are 3 unique accounts in the Customer column (Smith0123, Cooper0123 and Osbourne0123).

I am aware I can filter down to just show 0's and then remove duplicates and count the remaining, but I also need to do a count of unique accounts with a value and this is part of a bigger macro so needs to be a formula.

Many thanks

DC

Hi Alkey,

The second formula was exactly what I needed, however, when I now try to get a count of the unique customers with an invoice amount greater than 0 it is throwing up a #DIV/0! error.

Any advice on how to do this formula?

Many thanks

DC