E
Eán
Can I do a count formula to say 'count if does not contain'?
Many thanks
Eán
Many thanks
Eán
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
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
Like this
=COUNTIF(A1:A20,"<>Something")
Change something to whatever you want
same for checking numbers in a range
=COUNTIF(A1:A20,"<>2")
mike
J
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
=COUNTIF(A1:A10,"<>5")
=COUNTIF(A1:A10,"<>YES")
'If you mean blank
=COUNTBLANK(A1:A10)
If this post helps click Yes
J
Jacob Skaria
You can use COUNTIF() itself as;
=COUNTIF(A:A,"<>*YES*")
If this post helps click Yes
=COUNTIF(A:A,"<>*YES*")
If this post helps click Yes
T
T. Valko
=COUNTIF(A:A said:Can it be made case sensitive?
No, COUNTIF is not case sensitive.