Countifs with Multiple Criteria

Brittany Pair

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!

Paul Newcome

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"))

Paul Newcome

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

Brittany Pair

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})

Paul Newcome

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"))