View Single Post
  #4   Report Post  
Old April 5th 05, 11:12 AM
CLR
 
Posts: n/a
Default

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