COUNTIFS/CONTAINS - When more than one name is in a cell on the reference sheet

Jamie Bierman

=COUNTIFS({Linear Master Tracker - Series - Current Status}, NOT(OR(@cell = "Lost", @cell = "Passed", @cell = "Term Deal Completed/Expired", @cell = "Premiered")), {Linear Master Tracker - Series - Legal Exec}, CONTAINS($[Primary Column]@row, @cell))

In the below function, I am trying to get CONTAINS to work successfully. In {Linear Master Tracker - Series - Legal Exec} there can be multiple names from our Dropdown List, so when I reference the name of $[Primary Column]@row it is only coming up with data based off the first person listed in the referenced column.

I tried a CONTAINS function as well as FIND, but have not had success with either.

Jamie Bierman

This was the answer for anyone who may find it useful: part 1 of the COUNTIFS shown below

=COUNTIFS({Linear Master Tracker - Series - Legal Exec}, FIND($[Primary Column]@row, @cell) > 0,