Excel COUNTIF formula

Question

I have a spread sheet with a colomn with the following formula copied down

=IF(L3 = "N/A","No Action",(IF((J3<>""),(IF((K3<>""),(IF((K3>J3),"FALSE","TRUE")),"N/A")),"")))

which gives me the results below in column "M"

TRUE
TRUE FALSE
No Action
N/A
N/A
No Action
N/A
N/A
No Action
No Action
No Action

So I used the following formula in another sheet

=COUNTIF(Sheet1!M:M,"N/A") which gives "4"
=COUNTIF(Sheet1!M:M,"No Action") gives "5"

How ever =COUNTIF(Sheet1!M:M,"FALSE") or =COUNTIF(Sheet1!M:M,"TRUE")

Give the result "0"

I think this is due to "TRUE and FALSE" being keywords in excel but is there a way I can get excel to count the cells with these values without renaming them?

Answer 1

Please see MS Excel: COUNTIF Function (WS)

You should change the criteria to "=TRUE" like this:

=COUNTIF(A1:A11;"=TRUE")