Cool..........thanks Harlan...

Vaya con Dios,
Chuck, CABGx3


"Harlan Grove" wrote in message
...
"CLR" wrote...
=COUNTA(A1:A6) results as 6
=COUNT(A1:A6) results as 4
=COUNTA(A1:A6)-COUNT(A1:A6) results as 2
...

FWIW, the last formula could be replaced by

=COUNTIF(A1:A6,"*")