COUNTIFS with Not statement

ndaudio

I am encountering an error when trying to use a not statement in a countifs function when referencing different pages.

sudocode: From data on an external sheet provide the count for the following: Count the row if the health is green, and the project is not closed.

This is not compiling.

=COUNTIFS({PMO - Active Project List health}, "Green", NOT({PMO - Active Project List Status1}, "Closed"))

L_123

=COUNTIFS({PMO - Active Project List health}, "Green", {PMO - Active Project List Status1}, @cell <> "Closed"

L_123

=COUNTIFS({PMO - Active Project List health}, "Green", {PMO - Active Project List Status1}, @cell <> "Closed"

ndaudio

Thanks!