LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Art Art is offline
external usenet poster
 
Posts: 587
Default How to count cells which contain a formula that returns TRUE

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to not count cells which contain a formula that returns " "? Fiona Excel Worksheet Functions 10 April 5th 23 02:53 PM
=IF(test,true,false) only ever returns "true"? TagTech Excel Worksheet Functions 5 December 10th 08 03:04 PM
An if statment tat returns a true blank D Excel Worksheet Functions 4 August 29th 07 02:48 PM
Creating a count when the information from two cells is true. J. G. Skains Excel Worksheet Functions 2 August 2nd 07 10:16 PM
Code returns TRUE instead of value loren.pottinger Excel Discussion (Misc queries) 2 September 5th 06 05:21 PM


All times are GMT +1. The time now is 03:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"