Countifs On Cells With Multiple Entries

%3CLINGO-SUB%20id%3D%22lingo-sub-2150228%22%20slang%3D%22en-US%22%3ECountifs%20On%20Cells%20With%20Multiple%20Entries%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2150228%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20using%20the%20Countifs%20formula%20to%20count%20the%20number%20of%20times%20a%20name%20in%20the%20Name%20column%20is%20entered%20based%20on%20criteria%20in%20another%20column.%26nbsp%3B%20The%20issue%20I'm%20having%20is%20when%20a%20cell%20in%20the%20Name%20column%20has%20multiple%20names.%26nbsp%3B%20It%20appears%20Countifs%20matches%20the%20entire%20cell%20to%20my%20criteria%2C%20not%20if%20my%20criteria%20is%20contained%20in%20each%20cell.%26nbsp%3B%20Is%20there%20a%20way%20to%20get%20a%20count%20of%20a%20name%20when%20it%20is%20listed%20with%20other%20names%20in%20a%20cell%20from%20the%20Name%20column%20I'm%20referencing%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2150228%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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?

1 Reply

@DPolk2160 

Let's say the names are in B2:B50 and the name you're trying to count is in D2.

 

=COUNTIFS(B2:B50, "*"&D2&"*")