View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default How to count cells which contain a formula that returns TRUE

On Wed, 12 Aug 2009 03:26:01 -0700, Art wrote:

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


Post your formula. There is likely some error in how you are trying to do
this, as I cannot reproduce your problem here.
--ron