Thread: How to: COUNTIF when ISTEXT is True?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dpenny dpenny is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote