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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!