Need Formula Help: How to count multiple drop down values?

Jessie_Phillips

Problem Statement:

I have a sheet that was used in a form with multiple drop down selections and need to discover how to calculate total selected by category.

Need to count how many times apples was selected.

Example of column sheet:

Column Choices: apples, grapes, oranges, other

I have tried using the COUNTM formula and I keep getting an error. Here is the current formula being used:

=countm(reference other sheet), [apples])

What is wrong with my formula and how can I adjust to make it work? Thanks

Paul Newcome

@SmartWay360 Grouping in a report will not wok because you cannot group on a multi-select dropdown type column.

@Jessie_Phillips You will need a COUTINFS with a HAS function like so:

=COUNTIFS({Dropdown Column}, HAS(@cell, "Apples"))

SmartWay360

Hi,

The formula you are referring to is probably COUNTIF. More about it: COUNTIF Function | Smartsheet Learning Center.

However, I would recommend to consider using report of the sheet with grouping Fruits column and COUNT in the SUMARIZE tab.

Best,

Beata

Paul Newcome

@SmartWay360 Grouping in a report will not wok because you cannot group on a multi-select dropdown type column.

@Jessie_Phillips You will need a COUTINFS with a HAS function like so:

=COUNTIFS({Dropdown Column}, HAS(@cell, "Apples"))