Formula Help Please

  • Thread starter Thread starter TGB
  • Start date Start date
T

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
Click to expand...
of "IF", "COUNT", "COUNTIF", "AND", "OR" bur
 
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
.
Click to expand...
 
Back
Top