COUNTIFS and OR criteria

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

Best Answer

  • Aya
    Aya ✭✭✭
    edited 02/25/22 Answer ✓

    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

Answers

  • Aya
    Aya ✭✭✭
    edited 02/25/22 Answer ✓

    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

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!