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:
Best Answer
-
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
Answers
-
Or if there is any other better way to go about this - I am open to suggestions…
-
@Kelly Moore any chance you would be able to advise for this one?
-
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
-
@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
-
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
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!