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

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

Try this:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"dpenny" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> 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
>

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