I have a list of names in column B with some repeating. I use the following formula to count how many unique names are in the column.

=ArrayFormula(SUM(IFERROR(1/COUNTIF(B5:B,B5:B),0)))

I now want to reference data in column C, which are numbers, and only count the unique names in Column B if the correlating number in Column C is greater than 0.


Your help is appreciated.