Count open RAID items based off of dropdown menu

Allison H

I'm trying to get a count of open RAID items. We have the following statuses in the status dropdown: New, In Progress, Backlog, Requires Validation, and Complete.

What is wrong with this formula?:

=COUNTIFS([Type (RAAIDD)]:[Type (RAAIDD)], "Risk", Status:Status, OR(@cell = "New", @cell = "In Progress", @cell = "Requires Validation"))

Paul Newcome

I don't see anything wrong with the formula or the output. Based on the data in the screenshot, you only have one row that fits all of your criteria, more specifically the [Type (RAAIDD)] column having the text of "Risk".

Allison H

Thanks Paul!

Paul Newcome

Happy to help! 👍️