Excel - Count if does not equal

Asked By JR on 01-Dec-07 09:25 AM
How do i count the number of cells in a column that do not contain a certain
word or words.

Chip Pearson replied on 01-Dec-07 09:36 AM
If you want to count the non-blank cells that do not contain a given value,


This will not count blank cells.

If you want to include blank cells in the count, use


In both formula, change A1:B10 to your actual range of data.

Chip Pearson
Microsoft MVP  - Excel, 10 Years
Pearson Software Consulting
(email on the web site)