What am I doing wrong? Need total number of projects where health is red, by PM, and specific dept

KTwoods

=COUNTIFS({% Complete}, <1, {project health}, [Primary Column]2, {Safety Project Manager}, <>"", {Project Manager}, <>"", {Sponsoring Department}, ="Public Safety", {Sponsoring Department}, ="Public Safety - Support Services", {Sponsoring Department}, ="Public Safety - Police", {Sponsoring Department}, ="Public Safety - Fire")

Michelle Choate 2

Take out the equal signs and it should be fine.