Forum Discussion

Sean Craig's avatar
Sean Craig
Copper Contributor
Feb 14, 2018

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,...
Excel Desktop
Formulas & Functions
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Feb 14, 2018

Sean,

 

try this:

IF(AND(C15=C16,COUNTIF(U$7:U$30,O16),COUNTIF(U$7:U$30,"<>"&M12))
  • Sean Craig's avatar
    Sean Craig
    Copper Contributor
    Feb 14, 2018

    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.

Resources