Hi,

I'm trying to count the number of unique cells that don't have a "#" or "-" inside.

I have a column of cells that contain names. Some of these names are repeated, and some have characters such as "-" and/or "#" - I'm trying to exclude these cells from being counted.

I have 2 formulas that each does half of what I want, but I need to combine the 2 formulas to get the right answer:

This formula counts the number of unique cells (and takes care of blanks): =SUM(IF(COUNTIF(C4:C3689,C4:C3689)=0, "", 1/COUNTIF(C4:C3689,C4:C3689)))

This formula counts the number of cells that don't have a "#" or "-": =SUMPRODUCT(N(LEN(SUBSTITUTE(SUBSTITUTE(C4:C3689,"-",""),"#",""))=LEN(C4:C3689)))

The two formulas individually aren't very useful. Do you know how to combine the 2 formulas?

Thanks.