[email protected]’s Profile

Community member since June 2018

points
93
Company
Gainsight

2

Im trying to count the number of total number of "Open" "Risks" in another sheet

=COUNTIFS({RAID Log Range 1}, "Risk") + (COUNTIFS({RAID Log Range 2}, "Open"))

I only have 1 open risk but its returning 5. This is because its counting the total number of "open" AND "Risks" into my count. How do I