How to: COUNTIF when ISTEXT is True?

[dpenny]

How do I write a countif function on the criterion when ISTEXT is TRUE?
I cannot figure out the syntax.

And please don't say use COUNTA, it is not the same (specifically on
#N/A returned by Vlookup).

Also, why is an empty cell returned by Vlookup a zero having
ISNUMBER=True, while '345 returned by Vlookup has ISTEXT=True? Seems
inconsistent to me.

Thanks

Dick Penny

 

[Die_Another_Day]

This array formula seems to work. Not sure if there is an easier way.
=SUM(ISTEXT(A1:A5)*1)
Don't forget to press Ctrl+Shift+Enter after entering in the formula

HTH

Die_Another_Day

 

[Ragdyer]

Try this:

=COUNTIF(A:A,"*?")

 

[dpenny]

Both solutions worked - thank you.

Dick Penny