Count if it contains

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?

Find more posts tagged with

Accepted answers

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)

All comments

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! 👍️

Sign in to join the conversation!

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.