Countifs formula help for multiple dropdown selections
I am attempting to count different dropdown selections that have historically been amended. For example, where dropdown options were "Multi"; "M/A" but is now "Multi-Account", I need to count all 3 potential selections for a single year.
Where a single value has always existed, this is the formula I'm using:
=COUNTIFS({Master Sheet - Mentor Requests Range 7}, CONTAINS("Multi-Account",@cell), {Reporting Year}, "2022")
Thanks
Answers
-
Do you mean you are trying to count cells that contain either "Multi", "M/A", or "Multi--Account?
-
Yes that's correct.
-
Ok. Try this...
=COUNTIFS({Master Sheet - Mentor Requests Range 7}, OR(CONTAINS("Multi",@cell), CONTAINS("M/A",@cell)), {Reporting Year}, "2022")
I only specified "Multi" and "M/A" because "Multi" will also grab "Multi-Account"
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!