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



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!