Trying (without success) to use a contains with a Countif when referencing another sheet

CSPearsall

When I try this statement:

=COUNTIF({PM Assigned}, [PM Name]@row)

I get the number 55 - which is correct. The number of cells that EQUAL that value are 55

BUT I am looking for the number of cells that contain that value (Should be 56), but I have had zero luck with all of the combinations I have tried.

Any help?

To state I am looking for a count of the cells in the range {PM Assigned} that contain the string in the [PM Name] column of this row. - Count should be 56

Note: The {PM Assigned} range is a column with the type of dropdown

AKnight

Hey @CSPearsall !

Have you tried adding HAS to the second portion of your formula? Like:

=COUNTIF({PM Assigned}, HAS(@cell, [PM Name]@row))