Forum Discussion
Does not equal range or cell in Countif
Hello. I'm having trouble with the syntax for the argument to say "does not equal text in cell M12" with the portion of my formula below.
IF(AND(C15=C16,COUNTIF(U$7:U$30,O16),COUNTIF(U$7:U$30,...
Sean,
try this:
IF(AND(C15=C16,COUNTIF(U$7:U$30,O16),COUNTIF(U$7:U$30,"<>"&M12))
Thanks Detlef! I had tried that but was missing the <space> between
Detlef_Lewin wrote:
Sean,
try this:
IF(AND(C15=C16,COUNTIF(U$7:U$30,O16),COUNTIF(U$7:U$30,"<>"&M12))
< >. Cheers.