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
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
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.7K Get Help
 63 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!