Countifs with Multiple Criteria

Options

Hi - I need assistance with building a =COUNTIFS formula with multiple criteria. Here is my current equation (that I am getting a '0' on)

Current Equation: =COUNTIFS({B23 Delegation Registration Status Region}, "SOAF", {B23 Delegation Registration Status Registration G}, "Athlete" + "Unified Partner" + "Medical Staff" + "Additional Staff" + "Head Coach / Coach")

I am currently looking at a registration sheet for an event. I need to count how many registrations that have the criteria (for this example "SOAF") in the range {B23 Delegation Registration Status Region} , but also include the criteria of Athlete, Unified Partner, Medical Staff, Additional Staff and Head Coach / Coach in the range {B23 Delegation Registration Status Registration G}.

Is there another formula that I should be using to capture all of this criteria?

Thank you!

• ✭✭✭✭✭✭
Options

So it would be an either/or type of situation where you need to count if it equals "A" or "B" as opposed to both "A" and "B" at the same time in the same cell. In that case you would use something more like this:

=COUNTIFS({Range}, OR(@cell = "A", @cell = "B", @cell = "C"))

• ✭✭✭✭✭✭
Options

To count, would it have to contain all of those or at least one of them?

• Options

I need to count all of them! So I am looking to count registrations that include "SOAF" in their Region Column {B23 Delegation Registration Status Region} and their role needs to be either: Athlete, Unified Partner, Medical Staff, Additional Staff, or Head Coach / Coach (column: {B23 Delegation Registration Status Registration G})

• ✭✭✭✭✭✭