Total Count if value matching from multiselect cell

Preeti Kumar

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

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)