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

Find more posts tagged with

Accepted answers

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

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.