Countif value matching from multiselect cell

Preeti Kumar

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.

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 :-(.