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

Originally Posted by DC1986

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

I should be a similar formula with criteria >=0

Formula:

=SUMPRODUCT((B$2:B$10>=0)/COUNTIF(A$2:A$10,A$2:A$10&""))