Why didn't I think of that? <g

The formula I suggested is my "standard" uniques with criteria formula.

Biff

"Harlan Grove" wrote in message
oups.com...
T. Valko wrote...
This will account for both formula blanks ("") and empty cells (array
entered):

=SUM(N(FREQUENCY(IF((ISTEXT(B1:B20))*(B1:B20<"" ),MATCH(B1:B20&"",B1:B20&"",0)),
MATCH(B1:B20&"",B1:B20&"",0))0))

Or one could use

=SUMPRODUCT(ISTEXT(rng)*(rng<"")/COUNTIF(rng,rng&""))

as long as none of the values in rng contained wildcard characters *
and ? or began with =, <, , <, <= or =.