Countifs in a Column Properties with Multi Select

Charlene Stacy

I have a sheet collecting best times available for each of the 10 courses available, the multi select drop down is:

Monday Morning (7a-12p)

Monday Mid-Day (12p-4p)

Monday Evening (4p-9p)

Tuesday Morning (7a-12p)

Tuesday Mid-Day (12p-4p)

Tuesday Evening (4p-9p)

Wednesday Morning (7a-12p)

Wednesday Mid-Day (12p-4p)

Wednesday Evening (4p-9p)

I need to count how many of each is selected.

I set up second sheet as a metric to count, however when using the formula =COUNTIFS({Student Preferences210}, [Day of the Week & Time]@row) it only counts if one instance is in the cell. It does not count if there are multiple dates times selected.

Sheet that is collecting Student Preferences:

Metric Sheet that is counting the selections: =COUNTIFS({Student Preferences210}, [Day of the Week & Time]@row)

What is the best formula to count each Day of the Week & time that is selected in a mulit select?

Find more posts tagged with

Accepted answers

Genevieve P.

Hi @Charlene Stacy and @whitemd1964

When you're searching for a value in a multi-select field, you can use the HAS function to specify that you're looking to see if the cell has that value, like so:

=COUNTIFS({Student Preferences210}, HAS(@cell, [Day of the Week & Time]@row))

See: HAS Function

Cheers!

Genevieve

All comments

whitemd1964

I am hitting the same issue. did you get a response yet?

Genevieve P.

Hi @Charlene Stacy and @whitemd1964

When you're searching for a value in a multi-select field, you can use the HAS function to specify that you're looking to see if the cell has that value, like so:

=COUNTIFS({Student Preferences210}, HAS(@cell, [Day of the Week & Time]@row))

See: HAS Function

Cheers!

Genevieve

Charlene Stacy

The solution =COUNTIFS({Student Preferences210}, HAS(@cell, [Day of the Week & Time]@row)) works perfectly, 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.