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"))

Andre O

Could you also count apples and grapes and have those numbers combined in a count?

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

Would that work?

Paul Newcome

@Andre O You would need an OR function to count if it has apples or grapes in each cell.

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