What formula do I use to count individual items in a multi-select dropdown cell?

kmalone51256

I am trying to count individual items within a multi-select cell so that I can reflect the data in a chart in a Dashboard.

For example: If I want to find out how many people chose "Travel --- Reimbursement" in a multi-select field, how do I count just the "Travel --- Reimbursement" if various cells have other items in it (i.e. Travel --- Reimbursement, P-Card Payment, and Admin Tasks).

Any suggestions would be greatly appreciated!

Thanks!

Karen

Paul Newcome

Try something like this...

=COUNTIFS([Multi-Select Column]:[Multi-Select Column], CONTAINS("Travel --- Reimbursement", @cell))

Paul Newcome

Try something like this...

=COUNTIFS([Multi-Select Column]:[Multi-Select Column], CONTAINS("Travel --- Reimbursement", @cell))

kmalone51256

That totally did the job!! 😀 Thank you so much for your help!

Paul Newcome

Happy to help! 👍️

VictoriaBrowder

How do I count specific values from a multi select drop down on a different sheet? I have a data sheet to pull from for a dashboard and need to count how many times someone selects specific values and I want to know how many times each is selected. (Pricing/Budget, Complexity, Set of offerings/capabilities, Timing/Purchase Cycle, Outsourced IT Services, Other)

I've tried using =COUNTIF({ Rep Feedback Range 1}, CONTAINS("Pricing/Budget", {Sales Rep Feedback Range 1})) but the value says 0 instead of the actual amount.

Paul Newcome

@VictoriaBrowder Replace the second range with "@cell".

VictoriaBrowder

That was so easy! Thank you!!

Paul Newcome

@VictoriaBrowder Happy to help. 👍️

MANNA

Why is this formula =COUNTIFS([Multi-Select Column]:[Multi-Select Column], CONTAINS("Travel --- Reimbursement", @cell)) not working for me :(

Paul Newcome

@MANNA There could be any number of reasons. Are you getting an error message or an incorrect count?

MANNA

yes i got 0 when it supposed to be 1

MANNA

@Paul Newcome

Andrée Starå

Hi @MANNA

I hope you're well and safe!

Try something like this.

=COUNTIFS([Test Category]:[Test Category], HAS(@cell, "a"))

Did that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Paul Newcome

You will need to replace [Test Category]1 inside of the HAS function with @cell and then flip the order

HAS(@cell, "a")

MANNA

omg it work!!! thank you!!

Andrée Starå

@MANNA

Excellent!

Happy to help!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!