Countif not working in a table

[hutch27]

So I have a table in which i'm trying to add a check to see if any values in the last column of this table return a value of "FALSE" (it's worth mentioning that this "FALSE" is not strictly text - it's an IF formula result) . I'm using the CountIf formula but I can't seem to get it to work.

Here is my formula:

=IF(COUNTIF(Table_main[CHECK (GL Date)],"FALSE"),"YES","NO")

Here is an example of the table -

Column 1 Column 2 Column 3 Column 4
Name A 4/2/2018 4/3/2018 FALSE =IF(B2=C2,"TRUE","FALSE")
Name B 4/3/2018 4/3/2018 TRUE =IF(B3=C3,"TRUE","FALSE")
Name C 4/4/2018 4/4/2018 TRUE =IF(B4=C4,"TRUE","FALSE")

 

[josspong]

If you remove the quotes from "TRUE" and "FALSE" in all your formulas, it should work. Does that meet your needs?

 

[hutch27]

Ah!! it worked!