Hi - I am trying to create a COUNTIFS formula using three criteria in the same sheet - Status (I just want to count the Open items), Impacted IT Projects (which is another dropdown of project names to select from), and Severity (this column displays a "High", "Medium", or "Low" value based on the calculated score in column Risk Exposure Score (which is calculated by multiplying the value in the Impact column by the value in the Probability column).
This is the the only formula I've been able to get to work:
=COUNTIFS(Status:Status, "Open") + COUNTIFS(Severity:Severity, "High") + COUNTIFS([Impacted IT Projects]:[Impacted IT Projects], "IT Project Name 1")
But it is building the count independently for each column referenced instead of just giving me one total count that meets all three conditions.
Is a formula like this possible? Any help would be greatly appreciated!