COUNTIFS and NOT Formula Creation

Ruby Wood
Ruby Wood ✭✭
edited 04/04/22 in Formulas and Functions


I have a table of data that looks like this:

I am needing to create a formula that will count all of the "1" in each column, that do not contain "OPEN" in the name field. So far I have created this formula:

=COUNTIFS(Sun3:Sun27, 1, Employees3:Employees27, NOT("OPEN"))

Does anyone have an idea for a formula that will count all of the 1's connected to employees with names?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!