'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
---------------
Jacob Skaria


"Eán" wrote:

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

Many thanks

Eán