Checkbox And Text COUNTIF
I am looking for some help regarding a formula I am trying to get to work. I am trying to count of all boxes that are unchecked and have a text string that records the area STL. The check marked box represents a finished project and unchecked is unfinished and the text string represents the area of the project. I feel like I am missing something simple. Below is my formula that keeps returning #UNPARSEABLE.
=COUNTIF(Complete1:Complete396, 0) AND(Area1:Area396,="STL")
For a more simple breakdown
=COUNTIF(Checkmarkcell1:CheckmarkCell396, 0) AND(Textstring1:Textstring396,="STL")
Hey! You will be signed out in 60 seconds due to inactivity. Click here to continue using the site.