Formula Help Please

[TGB]

In another cell other than those being used put

=SUM(COUNTIF(B1:B500,"YES")+(COUNTIF(B1:B500,"NO")))

Then, in the cell (Xnn) that you want the zero or x, put

=IF(Xnn=A1,0,"X")

Regards / TGB

-----Original Message-----
Hi everyone,

I have a Number Total in cell A1.
In B1:B500 I have either the text "YES" or "NO".
What I want to do is to "COUNT" the number of "YES" and "NO" and if
that total agrees with the figure in A1 put a Zero, otherwise put an
"X".
I have tried combinations

of "IF", "COUNT", "COUNTIF", "AND", "OR" bur

 

[TGB]

I've corrected what I wrote - not thinking !!!

-----Original Message-----
In another cell (Xnn) other than those being used put

=SUM(COUNTIF(B1:B500,"YES")+(COUNTIF(B1:B500,"NO")))

Then, in the cell that you want the zero or x, put

=IF(Xnn=A1,0,"X")

Regards / TGB

of "IF", "COUNT", "COUNTIF", "AND", "OR" bur
.