Count if does not equal
 

How do i count the number of cells in a column that do not contain a certain
word or words.

Count if does not equal
 

If you want to count the non-blank cells that do not contain a given value,
use

=COUNTA(A1:B10)-COUNTIF(A1:B10,C1)

This will not count blank cells.

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

=(ROWS(A1:B10)*COLUMNS(A1:B10))-COUNTIF(A1:B10,C1)

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

--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)



"JRD" wrote in message
...
How do i count the number of cells in a column that do not contain a
certain
word or words.