Total Count if value matching from multiselect cell

Please help, i have 2 sheets.

One sheet (Second picture) contains week no. i.e. the week No (depending on a date) in which a member took leave or was absent.

The other sheet (First picture): I wanted to count total week numbers from that column only if week number is mentioned in multi select cell (under Week Number Column).like for first entry it will count only if week number is 4,8,13, 17 or 21...

Find more posts tagged with

Formulas

Accepted answers

All comments

David Tutwiler

I think you're looking for IF(CONTAINS(. Something like:

=IF(CONTAINS({Week No Lookup}, [Week Number]@row), COUNTM([Week Number]@row),0)

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.