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.
Help Article Resources
Check out the Formula Handbook template!