COUNTIFS one OR another criteria

Options

Hello, I am trying to find the number of cells in a column that are blank OR do not contain a specific word. I believe the way that I have it right now would be AND rather than OR. Any suggestions?

Need: If Accounting column is checked and Bio Status is blank OR does not contain "Posted"

I'm currently getting 1 as the total, but it should be 2


=COUNTIFS(Attorney:Attorney, 1, [Bio Status]:[Bio Status], "") + COUNTIFS(Attorney:Attorney, 1, [Bio Status]:[Bio Status], NOT(CONTAINS("Posted", [Bio Status]:[Bio Status])))

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!