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

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

Find more posts tagged with

Accepted answers

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

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.