Hi,
I am trying to create a summary sheet from a detailed project schedule and would to create a COUNTIF formula that adds to the countif sum if the row status column is "complete" and the internal milestone column is checked; however, I am receiving an #UNPARSEABLE error and not sure what the issue is.
Here is my formula:
=COUNTIFS({1250 Phase 1 Clubhouse Integrated Project Range 1}, "Complete", [{1250 Phase 1 Clubhouse Integrated Project Range 2}, "1"])
When I use the first criteria only on the formula, it works fine, however, I need the second criteria as I only want to count rows with the internal milestone box checked. I've also tried using "true" in place of "1"
