Hey everyone,
I am trying to create a formula that counts the cells that are true with two criteria and are flagged red.
=SUM(COUNTIFS({All Nexii HSE Incident Reporting Range 2}, "Hazard ID - Behavior", {All Nexii HSE Incident Reporting Range 1}, "Squamish", {All Nexii HSE Incident Reporting Range 3}, "Flag"))
The formula works great without the third criteria. Any suggestions on how to fix the third criterion? Recommendations are highly appreciated.