Thread: TRUE - Boolean vs. Text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Epinn Epinn is offline
external usenet poster
  
Posts: 605
Default TRUE - Boolean vs. Text
Biff or anyone,

Is this the only way to count both text "true" and logical TRUE?

=COUNTIF(A1:A10,"*true")+COUNTIF(A1:A10,"true")

Thanks.

Epinn


Reply With QuoteReply With Quote