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

"Eán" wrote:

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

Many thanks

Eán