Count If

[Eán]

Can I do a count formula to say 'count if does not contain'?

Many thanks

Eán

 

[Mike H]

Hi,

Like this

=COUNTIF(A1:A20,"<>Something")

Change something to whatever you want

same for checking numbers in a range

=COUNTIF(A1:A20,"<>2")

mike

 

[Jacob Skaria]

'If you mean a value;
=COUNTIF(A1:A10,"<>5")
=COUNTIF(A1:A10,"<>YES")

'If you mean blank
=COUNTBLANK(A1:A10)

If this post helps click Yes

 

[p45cal]

Can I do a count formula to say 'count if does not contain'?

Many thanks

Eán

Well I took 'contain' literally, so looked for a string withi
strings.
Case Sensitive:
=SUMPRODUCT(--(ISERROR(FIND("Get",C12:C18))))

Case insensitive:
=SUMPRODUCT(--(ISERROR(SEARCH("Get",C12:C18)))

 

[Jacob Skaria]

You can use COUNTIF() itself as;

=COUNTIF(A:A,"<>*YES*")

If this post helps click Yes

 

[p45cal]

You can use COUNTIF() itself as;

=COUNTIF(A:A,"<>*YES*")

If this post helps click Yes

Excellent!
Can it be made case sensitive

 

[T. Valko]

Can it be made case sensitive?

No, COUNTIF is not case sensitive.