COUNTIFS with OR

Hello,

I have spent hours trying to figure out what I am doing wrong, but I cannot seem to figure out what would get this formula to work. I am trying to count if my Simulation column says Phillips, the complete checkbox is checked and Type is Pilot OR Simulation. The formula works fine up until I add in the Type being Pilot or Simulation. I thought maybe it is because the logical expression is incomplete?

=COUNTIFS(Simulation:Simulation, "Phillips", Complete:Complete, 1, OR(Type:Type, "Pilot", Type:Type, "Simulation"))

Find more posts tagged with

Formulas

Accepted answers

Frank S.

Greetings Erin,

Here is the formula I think should resolve your problem:

=COUNTIFS(Simulation:Simulation, "Phillips", Complete:Complete, "1", Type:Type, OR(@cell = "Pilot", @cell = "Simulation"))

For the OR statement, you can reference the @cell for your comparisons.

Please let me know how this works.

All comments

StefanieM

I think it might be because you need parentheses around your first scenario...

=COUNTIFS((Simulation:Simulation, "Phillips", Complete:Complete, 1), OR(Type:Type, "Pilot", Type:Type, "Simulation"))

Frank S.

Greetings Erin,

Here is the formula I think should resolve your problem:

=COUNTIFS(Simulation:Simulation, "Phillips", Complete:Complete, "1", Type:Type, OR(@cell = "Pilot", @cell = "Simulation"))

For the OR statement, you can reference the @cell for your comparisons.

Please let me know how this works.

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.