Countif when multiple values

I have a form that allows users to multi select.

I have a metrics sheet that counts the number of times a selection appears, however, it's only working for those that only had a single value selected. Multi-select are NOT being counted.

Is there a way to get counts when there are multiple values in the same cell?

Here's the formula I'm using right now.

=COUNTIF({Request Tracker Range 4 - Request Type}, Category9)

Find more posts tagged with

Accepted answers

Mark.poole

@TraisHorloff

The order of the function calls matter. In this cause you want.

=COUNTIF({Request Tracker Range 4 - Request Type}, OR(HAS(@cell, "Category9"), HAS(@cell, Category10")))

All comments

Mark.poole

@darrink

=COUNTIF({Request Tracker Range 4 - Request Type}, HAS(@cell,Category9))

darrink

Thanks @Mark.poole I will give it a shot!

TraisHorloff

https://community.smartsheet.com/discussion/comment/440968#Comment_440968

How would the formula look like if the cells I'm counting have multiple values. This one doesn't seem to be working as it always show 0. Thanks for your help.

=COUNTIF({Request Tracker Range 4 - Request Type},HAS(@cell,OR(@cell="Category9",@cell="Category10")))

TraisHorloff

To clarify, I want to count the items, which have "Category9" or "Category10". The cells have multiple values "Category1" to "Category10".

Mark.poole

@TraisHorloff

The order of the function calls matter. In this cause you want.

=COUNTIF({Request Tracker Range 4 - Request Type}, OR(HAS(@cell, "Category9"), HAS(@cell, Category10")))

TraisHorloff

@Mark.poole

That's it, thank you!

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.