How to exclude values from a COUNTIF expression

Tim Möhle
edited 12/09/19 in Formulas and Functions

I'm writing a COUNTIF formula referencing a column with multiple values that works well, until I try to build an expression that says:

I want you to count the values in this column as long as they are NOT "x" OR "y" OR "z".

Can anyone help with the proper syntax?  I've tried the following but it doesn't work:

COUNTIF ({Reference}, OR(@cell<>"x", @cell<>"y", @cell<>"z"))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!