COUNTIF not working with string "True" or "False"

Question

I have this very simple columns of either string True or False.

I am trying to use this formula = COUNTIF(F2:F, "True") to get the number of True in the column. But its not working. It works with other strings such as apples, but never with True or False.

How do you compare that?

Answer 1

Adding a wildcard at the end of the string seems to work well for both true and false text strings.

=COUNTIF(F2:F13,"Tru*")

However it runs the risk of matching unwanted strings, for example the text string TrueThat would be matched by "Tru*"

Answer 2

Please try:

=countif(F2:F,"'"&"True")

(Or better still, avoid True and False as Text.)