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?
Best Answer
-
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)
Answers
-
Try using this...
=COUNTIF({Action Log Range 3}, CONTAINS(Name1, @cell))
-
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?
-
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)
-
Thank you Paul.... very, very much!
-
Happy to help! 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!