COUNT a certain criteria from a dropdown list

System

This discussion was created from comments split from: CountIf for check boxes.

Shadany

Hello,

I was wondering if I could get some help with a formula. I tried following some formulas that I saw on this thread but it doesn't seem to be giving the data back as it just returns a 0. I'm trying to count the amount of times a certain criteria is selected from a column from a dropdown list. The columns do have multiple selections from the dropdown. I am referencing from another sheet. I would also like to only count if it's the current month. I do have helper columns, in which it returns "Yes" if its the current month. I then use that column as a criteria. I have two formulas that I tried but it doesn't seem to work. Any advice?

Paul Newcome

Try this:

=COUNTIFS({Range 1}, @cell = "Yes", {Range 2}, HAS(@cell, [Primary Column]@row))

Jeff Reisman

@Shadany You are on the right track using the HAS function with your multi-select column value. With a few small tweaks we can make this work for you.

Try this:

=COUNTIFS({Production Data Range 1}, "Yes", {Production Data Range 2}, HAS(@cell,"1-Mechanical Adjustments"))

Shadany

https://community.smartsheet.com/discussion/comment/361952#Comment_361952

Hi Jeff,

Thank you that worked!

Jeff Reisman

https://community.smartsheet.com/discussion/comment/361958#Comment_361958

Excellent! If you could mark my answer as accepted, that would be great.