Your formula is producing the text string "TRUE", not the logical value
TRYE. Get rid of the quote marks.
--
David Biddulph

"Art" wrote in message
...
It works in your example, but not in my particular case :(
I'm using:
=IF(AND(C181=1,G181=0,J181=1), "TRUE", "")
this returns TRUE or nothing.
I just want simply count the cells returning TRUE.
Grrrr
Thanks,

"Gary''s Student" wrote:

In A1 thru A7 enter:
=1=1
In A8 thru A10 enter:
=1=2

We see in A1 thru A10:
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
TRUE
FALSE
FALSE
FALSE

in another cell enter:
=COUNTIF(A1:A10,TRUE)
which correctly displays 7
--
Gary''s Student - gsnu200860


"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