Skip to content
Home
Tutorials
Real-World Examples
Count cells that do not contain a specific value
Update Formula
Parameters
Formula
Range Reference:
Specific Value:
enter the value that you want to count for if it doesn't exist:
Formula:
=
COUNTIF
(
B5:B7
,"<>"&"*
Exceldome
*")
=
COUNTIF
(B5:B7,"<>"&"*Exceldome*")