Countif value matching from multiselect cell

Please help, i have 2 sheets. One sheet contains week no. i.e. the week in which a member is absent. I wanted to count week numbers from that column only if week number is mentioned in other sheet under (multi select cell). Ì used this COUNTIFS({Team Vacation Planner Range 2}, [Assigned To]@row, {Team Vacation Planner Range 1}, CONTAINS([Week Number]@row, @cell)) but it's not working.

Find more posts tagged with

Formulas

Accepted answers

All comments

Dale Murphy

@Preeti Kumar I'm not sure why you are using COUNT, so I may miss your point.

This seems to work. It returns a 1 when it sees a match, but zero when [Non working] is not found in [Week Number].

(replace [Non Working]3 with [Non Working]@row to generalize.

Does that get you what you want?

Cheers,

Dale

Preeti Kumar

Hey Dale,

Thank you so much for the help. Sorry for the confusion, i basically wanted to sum the number of days a person is absent from the weeks mentioned in multiselect cell. Just getting yes or no will not help me :-(.

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.