Im looking to count the number of times specific ranges happen from 2 separate columns. Essentially, I want to count number of issues open by Priority, excluding 3 different status types.
Current formula only excluding "Resolved"
=COUNTIFS({Priority}, "1 - Critical", {Status}, <>"Resolved")
Need formula to exclude multiple status types
=COUNTIFS({Priority}, "1 - Critical", {Status}, <>"Resolved") + {Status} <> Support Ticket + {Status} <> Change Request
This is not working
=COUNTIFS({Intuitive Integration Testing Issue Tracke Range 2}, "2 - High", {Intuitive Integration Testing Issue Tracke Range 1}, <>"Resolved") + COUNTIFS({Intuitive Integration Testing Issue Tracke Range 2}, "2 - High", {Intuitive Integration Testing Issue Tracke Range 1}, <>"Support Ticket") + COUNTIFS({Intuitive Integration Testing Issue Tracke Range 2}, "2 - High", {Intuitive Integration Testing Issue Tracke Range 1}, <>"Change Request")