How do I Count the rows on a "Contact List" column, for the current user?

Art Jones

Example: I list team members in a Contact List by project. Team members range from 0 to 5 team members:

Goal: count each team member's occurrences on 3 projects. Art Jones, Janice Doe, Terry Tonsil, Mary Green.

Project Team Members (Contact list)

Market Art Jones, Janice Doe.

Inventory Terry Tonsil, Janice Doe, Mary Green.

Party Art Jones, Janice Doe,

I'd like an answer 😀 of: 3 Janice Doe, 2 Art jones, 1 Terry Tonsil, 1 Mary Green.

Paul Newcome

Try something like this (assuming the count is on a different sheet):

=COUNTIFS({Contact List Column}, HAS(@cell, "Janice Doe"))