| Home |
| Search |
| Today's Posts |
|
#14
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to count cells which contain a formula that returns TRUE
On Wed, 12 Aug 2009 04:16:02 -0700, Art wrote:
=IF(AND(C181=1,G181=0,J181=1), "TRUE", "") this returns TRUE or nothing. I just want simply count the cells returning TRUE. I've tried both formulas: =COUNTIF (A1:A10,TRUE) or =COUNTIF(A1:A10,"TRUE") Both give 0 in my case. Thanks, And, of course, you could also change the COUNTIF formula: =COUNTIF(A1:A10,"*TRUE") --ron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to not count cells which contain a formula that returns " "? | Excel Worksheet Functions | |||
| =IF(test,true,false) only ever returns "true"? | Excel Worksheet Functions | |||
| An if statment tat returns a true blank | Excel Worksheet Functions | |||
| Creating a count when the information from two cells is true. | Excel Worksheet Functions | |||
| Code returns TRUE instead of value | Excel Discussion (Misc queries) | |||
Threaded Mode
