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"))
