How to: COUNTIF when ISTEXT is True?
 

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


--
dpenny
------------------------------------------------------------------------
dpenny's Profile: http://www.excelforum.com/member.php...o&userid=19708
View this thread: http://www.excelforum.com/showthread...hreadid=559997

How to: COUNTIF when ISTEXT is True?
 

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

dpenny wrote:
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


--
dpenny
------------------------------------------------------------------------
dpenny's Profile: http://www.excelforum.com/member.php...o&userid=19708
View this thread: http://www.excelforum.com/showthread...hreadid=559997

How to: COUNTIF when ISTEXT is True?
 

Try this:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"dpenny" wrote in
message ...

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


--
dpenny
------------------------------------------------------------------------
dpenny's Profile:
http://www.excelforum.com/member.php...o&userid=19708
View this thread: http://www.excelforum.com/showthread...hreadid=559997

How to: COUNTIF when ISTEXT is True?
 

Both solutions worked - thank you.

Dick Penny


--
dpenny
------------------------------------------------------------------------
dpenny's Profile: http://www.excelforum.com/member.php...o&userid=19708
View this thread: http://www.excelforum.com/showthread...hreadid=559997