In Excel how to count NON-BLANK cells having ONLY Non-numeric values in a range?

It has many ways, for example:

(Assuming all values are in the column "A"):

1) =COUNTIF(A:A;"*")

2) =COUNTA(A:A)-COUNT(A:A)

many ways 

for example

say : values are existed in column A

we can use this formula

=counta(a1:a11) - count(a1:a11)=5

thanks 

Count if function can be used for this and it can be modified in many ways.

=+COUNTIF(B3:J3,"*"). In this * indicates any text.

* can be replaced by <0 to get the count of -ve numbers, >0 for +ve numbers and so on.

by using

=COUNTIFS function we can get the answer 

apply this formula

=countblank(eg a1 to b31)

use your eyes

In openion, we can count Blank Cell  as per below:

Apply filter  in that particuler area: then in select Non Blank Cell in list down box

Then select all blank cell in that area thn in bottom of Excel bar you can view number of blank cell you selected.

You Can Make The CountA-Count 

Or You Can Use This Only 

=COUNTIF(A1:A7,">0")+COUNTIF(A1:A7,"<0") ( For No# )

Or

=COUNTIF(A1:A7,"*") ( For Words )

=Counta(Range)-Count(Range)

CountA counts all Non Blanks

Count Counts Non blank numerics