How to: COUNTIF when ISTEXT is True?

D

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
 
D

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
 
Top