COUNTIF with OR

I am trying to count all instances of a name where the corresponding status is Open or Tracking.

My formula is =COUNTIFS({Coordination Log - Autumn Willow Range 1}, "Chris Rush", {Coordination Log - Autumn Willow Range 2}, OR(@cell = "Open", @cell = "Tracking"))

In the last portion where the OR comes into play, I initially tried having the range {Coordination Log - Autumn Willow Range 2} = to "Open" and "Tracking" but that yielded #INVALID OPERATION.

My current fomula should output a value of 4, but I am getting 0. Is this perhaps a syntax error where I have @cell = "Open"/"Tracking" ?

NOTE: I am trying to count the name within a multi-select contact column. Will I need to use a COUNTM?

Find more posts tagged with

Formulas

Countif

Accepted answers

Leibel S

@atewari1

You need to use the HAS function to check if the column has the name Chris Rush:

=COUNTIFS({Coordination Log - Autumn Willow Range 1}, HAS(@cell, "Chris Rush"), {Coordination Log - Autumn Willow Range 2}, OR(@cell = "Open", @cell = "Tracking"))

All comments

Leibel S

@atewari1

You need to use the HAS function to check if the column has the name Chris Rush:

=COUNTIFS({Coordination Log - Autumn Willow Range 1}, HAS(@cell, "Chris Rush"), {Coordination Log - Autumn Willow Range 2}, OR(@cell = "Open", @cell = "Tracking"))

atewari1

@Leibel S You my good friend are brilliant. It works! Thank you so much!

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.