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.
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
(email on the web site)