Counting items from a multiple drop down list
I have a list of action items that can be assigned to several departments by using a multiple drop down list with dept. names in the assigned column
I am trying to create a summary sheet to count the number assigned
I have tried both Contains & HAS
But my answer is 0 - Just using the count if gets me 23 and there are 2 where multiple depts are chosen including OPS so I should have 25.
Using HAS
Once again my answer is 0
The {LL Action Tracker Range 1} is my assigned row in my main sheet
Thank you!
Best Answers
-
-
Hi @Amy A
Try this:
=COUNTIFS({LL Action Tracker Range 6}, <>"", {LL Action Tracker Range 1}, HAS(@cell, Section@row))
With a COUNTIFS you'll always want to list the {column} first, then your criteria. The HAS is the criteria, which is why we list is after the {range}. Let us know if this makes sense!
Cheers,
Genevieve
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
Answers
-
-
Thank you very much!!
-
I was hoping by helping me with this item, I could figure out my countifs but no such luck.
I am trying to also then identify these counts on my summary as completed & open by priority.
This above has worked for my countif
This has worked for my completed: =COUNTIFS({LL Action Tracker Range 6}, <>"", {LL Action Tracker Range 1}, Section@row) - but does not include those with multiple dropdown - I have tried the HAS & CONTAINS formula with no luck
Is NOT working:
=COUNTIFS({LL Action Tracker Range 6}, <>"", CONTAINS(Section@row, {LL Action Tracker Range 1}))
-
Hi @Amy A
Try this:
=COUNTIFS({LL Action Tracker Range 6}, <>"", {LL Action Tracker Range 1}, HAS(@cell, Section@row))
With a COUNTIFS you'll always want to list the {column} first, then your criteria. The HAS is the criteria, which is why we list is after the {range}. Let us know if this makes sense!
Cheers,
Genevieve
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!