Using COUNTIF with OR

I'm trying to figure out how to add OR to this statement. Below I'm finding the count of Primary, CAS, Archive, and where Course Development is checked. This works fine. I need to find the same thing now but instead of a singular phase as Archive, I need to find phases such as Concept or Agreement, or Prototype.

=COUNTIFS([College/Unit]:[College/Unit], "CAS", Phase:Phase, "Archive", [ID Tier]:[ID Tier], "Primary", [Work Category: Course Development]:[Work Category: Course Development], "1")

Thanks!

Find more posts tagged with

Accepted answers

Leibel S

@jessicawstage

Try this:

=COUNTIFS([College/Unit]:[College/Unit], @cell="CAS", Phase:Phase, or(@cell="Concept",@cell="Agreement",@cell="Prototype"), [ID Tier]:[ID Tier], @cell="Primary", [Work Category: Course Development]:[Work Category: Course Development], @cell=1)

All comments

Leibel S

@jessicawstage

Try this:

jessicawstage

Thank you so much! This worked!

Would you be able to explain to me how using the @cell made the difference here? I tried that before and clearly wasn't using it correctly, but I'm confused about exactly what the expression is doing.

Thank you!

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.