Countif w/ multi drop down
Hi,
I have a list of drop down items:
I am trying to total the amount of those selected on another sheet. (How many rows contain those three items bundled together). I am getting an error message when I try:
=COUNTIFS({LOA Tracker Range 2}, "Jordan Own", {LOA Tracker Range 5}, "FMLA" AND "CFRA" AND "Wave Parental Leave")
What am I missing?
Thanks! :)
Best Answer
-
I goofed the syntax. Try:
=COUNTIFS({LOA Tracker Range 2}, "Jordan Own", {LOA Tracker Range 5}, AND(HAS(@cell, "FMLA"), HAS(@cell,"CFRA"), HAS(@cell,"Wave Parental Leave")))
Work this time?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Answers
-
Try:
=COUNTIFS({LOA Tracker Range 2}, "Jordan Own", {LOA Tracker Range 5}, HAS(@cell, AND("FMLA", "CFRA", "Wave Parental Leave"))
The HAS function return true if the multiselect cell has the exact content and false if not.
Work?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Hi Mark,
It is showing as 0, even though there are those combinations...
-
I goofed the syntax. Try:
=COUNTIFS({LOA Tracker Range 2}, "Jordan Own", {LOA Tracker Range 5}, AND(HAS(@cell, "FMLA"), HAS(@cell,"CFRA"), HAS(@cell,"Wave Parental Leave")))
Work this time?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Yay this worked! Thank you!!!
-
Excellent. Glad you found a solution. Please accept an answer to close the discussion. Thank you for contributing to the Community.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!