Countifs in Sheet Summary Not correct Result


This formula is in my project plan summary sheet. I want to count the rows where Level = 2.1 or Level = 3.1 and Status = "Not Started.

This is my formula:

=COUNTIFS(Status:Status, "Not Started", Level:Level, "2.1", Level:Level, "3.1")

It returns a 0. and it should be 11.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!