I'm trying to count distinct text values in a range. I found this formula on another help site
=SUM(IF(A2:A10<>"",1/COUNTIF(A2:A10, A2:A10), 0))
.... but it gives me a self-referencing error and returns 0 (My formula is placed in column B).
Thanks in advance.