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

PKane

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:

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

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