Hi, I used the formula as:

=COUNTIF(A1:A1000, "<>" ""), but this resulted in a error.

Basically, in cells A1:A1000, some cells have one blank space" ".