Excel 2007 : Formulas that reference cells with formulas

[grey_fox33]

I have a column I that consists of a formula, something like =IF(H3>$O$2,"TRUE","")

I have a countif formula that I want to use to count the number of "TRUE" in this column
=COUNTIF(I:I,"TRUE")
however it does not work. It always is 0. I guess because I have formulas in the cells, it will not work. If I actually manually type TRUE anywhere in column I, then it will get counted.

How do I countif to work for a column with formula data in it?

[jeffreybrown]

Try this

=IF(H3>$O$2,TRUE,"")

then

=COUNTIF(I:I,TRUE)

True does not require quotes