Help with COUNTIFS Formula w/ multiple possible criteria in the same column

I am looking to create a formula that can count a couple of items and if any of 3 possible solutions are in play. Any help that anyone can lend would be appreciated.

Items I am looking to count:

'Carrier Initiated TDM' is checked and the status is 'In Progress' and if the Scope/Decision/Solution is any of these 3 possible scope options:

'Add Temp Cell'
'Add temp cell, Disconnect'
'Disconnect, Add temp cell'

What I have tried for a formula - but its returning 0:

=COUNTIFS({T1 Scope}, "Add temp cell, Disconnect", {T1 Scope}, "Add Temp Cell", {T1 Scope}, "Disconnect, Add temp cell", {Carrier initiated TDM}, 1, {T1 to Temp Cell Status}, "In Progress")

Here is a snip of my sheet:

Find more posts tagged with

Accepted answers

Kelly Moore

@PKane

Try this:

=COUNTIFS({Carrier Initiated TDM}, 1, {T1 to Temp Cell Status}, "In Progress", {T1 Scope}, OR(@cell = "Add Temp Cell", @cell = "Add temp cell, Disconnect", @cell = "Disconnect, Add temp cell"))

Will this work for you?

Kelly

All comments

PKane

Or if there is any other better way to go about this - I am open to suggestions…

PKane

@Kelly Moore any chance you would be able to advise for this one?

Kelly Moore

@PKane

Try this:

=COUNTIFS({Carrier Initiated TDM}, 1, {T1 to Temp Cell Status}, "In Progress", {T1 Scope}, OR(@cell = "Add Temp Cell", @cell = "Add temp cell, Disconnect", @cell = "Disconnect, Add temp cell"))

Will this work for you?

Kelly

PKane

@Kelly Moore thank you so very much for your help! It works great. After looking at the community boards regarding similar topics I figured you might be the right person to ask. Thanks again! #herostatus

Kelly Moore

@PKane

I’m glad this worked for you. I did wonder if your OR choices were the only choices (in your full list of choices) that had the phrase “Add temp cell” in the selection. If yes we could have used a CONTAINS instead of the hard-coded OR criteria. It was just something I wondered

Shout out anytime

Kelly

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.