It's the SumProduct version of Hager's formula extended to take care of
formula-blanks and empty cells,

{=SUM(IF(A1:A10<"",1/COUNTIF(A1:A10,A1:A10)))}

Duke Carey wrote:
I like yours MUCH better, Peo

"Peo Sjoblom" wrote:


One way

=SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&""))


Regards,

Peo Sjoblom

"Rob Kaiser" <Rob wrote in message
...

I am looking for a command/formulat to count (return a single number) the
number of unique text entries in a column.