Count dropdown values

ScottPinson_AlliedSolutions

Good evening, I am looking for help on a formula. I am looking to reference another sheet and count how may times a value appears in a drop-down multi-list.

thanks in advance...

Genevieve P.

Hi @ScottPinson_AlliedSolutions

Try using the HAS function within @Andrée Starå's formula... like this:

=COUNTIF({Source}, HAS(@cell, "Red"))

The HAS function is built specifically for multi-select drop-down lists, and will check to see which cells have that criteria, whether or not there are other selections in the cell as well.

Let us know if this works for you!

Cheers,

Genevieve

Andrée Starå

Hi @ScottPinson_AlliedSolutions

Try something like this.

=COUNTIF({Source}; "Value")

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

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

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

ScottPinson_AlliedSolutions

Thanks for the post Andree, I tried that but that only counts the cells that are equal to the value not the ones that contain the value. For example, if the dropdown contains 4 values (Red, Blue, Green, Black) and I use =Countif({Source},"Red") it will not count that cell).

Thanks

Scott

Genevieve P.

Hi @ScottPinson_AlliedSolutions

Try using the HAS function within @Andrée Starå's formula... like this:

=COUNTIF({Source}, HAS(@cell, "Red"))

The HAS function is built specifically for multi-select drop-down lists, and will check to see which cells have that criteria, whether or not there are other selections in the cell as well.

Let us know if this works for you!

Cheers,

Genevieve

Andrée Starå

@ScottPinson_AlliedSolutions

Happy to help!

I saw that Genevieve answered already!

Let me know if I can help with anything else!

Best,

Andrée

ScottPinson_AlliedSolutions

@Genevieve, thank you. That worked, I ended up using contains formula but same result.

=COUNTIF({Project ID2}, CONTAINS(Label@row, @cell))

Thanks for the responses.

Great community support!

Genevieve P.

Hi @ScottPinson_AlliedSolutions

Glad you figured something out!

Keep in mind that CONTAINS will find partial matches... so if your content in the Label column has "App" and another row has "Apple", then CONTAINS will see "Apple" as a match for "App" since it contains those letters. (Versus HAS, which looks for exact matches.)

If all your values in the Label column are unique and not found within other values then Contains will work just fine.

Cheers!

Genevieve