Countifs w/ not contain function referencing another spreadsheed

shawn liston

I have column (status) that has multiple valid options that I want to count but i"m referencing a separate sheet (using a project rollup method given we don't have pivot app)

what is the syntax for this ? =COUNTIFS({project Range 2}, "TMS", NOT(CONTAINS{"Closed", "Complete", Project plan Range 4}

Mark.poole

@shawn liston

=countifs({project range 2}, “TMS”, {Project Plan Range 4}, Not(or(Contains(@cell, “Closed”),Contains(@cell, “Complete”))))