Thread: How to count cells which contain a formula that returns TRUE
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default How to count cells which contain a formula that returns TRUE
Are you sure that your formula is returning the boolean value TRUE and not
the text string "TRUE" ?
--
David Biddulph

"Art" wrote in message
...
The question in princilpe refers to any cell that contain formula.I\ve
noticed that if I use COUNTIF on cells that contains formula returning
TRUE
it doesn't count.It count only if I simply type TRUE in the cells


Reply With QuoteReply With Quote