Countifs with Or Function

I'm trying to count people from another sheet where the goal year equals the one reference on the current row and the Status could be a few other options, so I thought the easiest would be the OR function with counting everything including blank, but not "Agent Not in Count".

The formula below gives me an #Unparseable error.

=COUNTIFS({Goal Year}, Year@row, {Status}, OR(@cell <>"Agent Not in Count", @cell ""))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!