View Single Post
  #3   Report Post  
Harlan Grove
 
Posts: n/a
Default

"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,"*")