ExcelBanter - Count If

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Count If (https://www.excelbanter.com/excel-worksheet-functions/242659-count-if.html)

Eán[_2_]

Count If

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

Many thanks

Eán

Mike H

Count If

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

Jacob Skaria

Count If

'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

All times are GMT +1. The time now is 06:54 AM.