COUNTIF Formula with 2 Criteria - Status & Checkbox

NiAlex

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"

COUNTIFs row.PNG

NiAlex

Got it:

=COUNTIFS({Other sheet Range 1}, "Complete", {Other sheet }, =1)