Hi,

Try this

=COUNTA(A1:A6)-COUNT(A1:A6)

Mike

"DonArturo" wrote:

I would like to be able to count the number of cells within a range that
contain text, excluding those that are strictly numeric values. For example,
counting:
34
52
n/a
987
ooops
4
would return the result of 2.