Count if it contains

Lisa-B

I have an action log - allocations vary between one person only and multiple persons.

Want to do a count (in a separate file) of allocations to each team member. This formula:

=COUNTIF({Action Log Range 3}, Name1) counts only those actions allocation to ONLY that team member.

--- Action Log Range 3 = action allocated to...; Name1 = names listed in my sheet with formulae ---

How do I change the formula to say that in the Action Log Range, if it contains the name listed in my sheet, then it counts it as one?

Paul Newcome

Are you using a contact type column? If so then you would need to use a FIND instead of CONTAINS.

=COUNTIF({Action Log Range 3}, FIND(Name1, @cell) > 0)

Paul Newcome

Try using this...

=COUNTIF({Action Log Range 3}, CONTAINS(Name1, @cell))

Lisa-B

My answer changes from 3 to 0 - I know that it should be 5 if it counts all actions allocated individually + as part of the group.

Thanks - any other ideas for me please?

Paul Newcome

Are you using a contact type column? If so then you would need to use a FIND instead of CONTAINS.

=COUNTIF({Action Log Range 3}, FIND(Name1, @cell) > 0)

Lisa-B

Thank you Paul.... very, very much!

Paul Newcome

Happy to help! 👍️