COUNTIFS one OR another criteria
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])))
Help Article Resources
Check out the Formula Handbook template!