COUNTIFS and OR criteria

AdaH

Hello,

I am trying to create a formula to pull from two different columns where one has multiple "or" scenarios. For example, I need a count of rows that = "Not Started" and is either = "BD, Bid Mgmt, CRO, Customer, Product, Sales, or Other". Below is what I've been trying and it's not working. Appreciate the help!

=COUNTIFS({Advocacy Placement Tracker Range 1}, "Not Started", {Advocacy Placement Tracker Range 3}, "BD", OR {Advocacy Placement Tracker Range 3}, "Bid Mgmt", OR {Advocacy Placement Tracker Range 3}, "CRO", OR {Advocacy Placement Tracker Range 3}, "Customer", OR {Advocacy Placement Tracker Range 3}, "Product", OR {Advocacy Placement Tracker Range 3}, "Sales", OR {Advocacy Placement Tracker Range 3}, "Other")

Aya

Hi Adah,

Try this:

=COUNTIFS({Advocacy Placement Tracker Range 1}, "Not Started", {Advocacy Placement Tracker Range 3}, AND(OR(@cell="BD", @cell="Bid Mgmt", @cell="CRO", @cell="Customer", @cell="Product", @cell="Sales", @cell="Other")))

-Aya

Aya

Hi Adah,

Try this:

=COUNTIFS({Advocacy Placement Tracker Range 1}, "Not Started", {Advocacy Placement Tracker Range 3}, AND(OR(@cell="BD", @cell="Bid Mgmt", @cell="CRO", @cell="Customer", @cell="Product", @cell="Sales", @cell="Other")))

-Aya

AdaH

Thank you, Aya. This works! Appreciate the quick response.