I'm using the Countifs formula to count the number of times a name in the Name column is entered based on criteria in another column. The issue I'm having is when a cell in the Name column has multiple names. It appears Countifs matches the entire cell to my criteria, not if my criteria is contained in each cell. Is there a way to get a count of a name when it is listed with other names in a cell from the Name column I'm referencing?
