Guidance requested- Count if two drop downs options are both selected in one cell
Hi I'm trying to get a count of the number of times 2 specific dropdowns are selected in a given cell in a specific column, where the project line item does not have a specific dropdown selected in separate timing column. e.g. count the number of instances where the [Sequencing Dependencies] column has both "Dropdown option 1" and "Dropdown option 2" selected, and Timing Column does not equal "future". I've tried various combinations using CONTAINS, HAS, AND, but am hitting a wall. Here is one of the variations I've tried as an example..
=COUNTIFS([Sequencing Dependencies]:[Sequencing Dependencies], CONTAINS(AND("Dropdown option 1", @cell), ("Dropdown option 2", @cell), Timing:Timing, <>"Future"))
Thank you!
Best Answer
-
Try this...
=COUNTIFS([Sequencing Dependencies]:[Sequencing Dependencies], AND(CONTAINS("Dropdown option 1", @cell), CONTAINS("Dropdown option 2", @cell)), Timing:Timing, <>"Future")
Answers
-
Try this...
=COUNTIFS([Sequencing Dependencies]:[Sequencing Dependencies], AND(CONTAINS("Dropdown option 1", @cell), CONTAINS("Dropdown option 2", @cell)), Timing:Timing, <>"Future")
-
You rock!!- thanks Paul! that worked:)
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!