Trying to see how many projects are assigned and how many are assigned as initiative resource

Options

I have a project sheet that I need to pull into a dashboard and show the count for each project manager that are primary then also show how many they are secondary for. I am having issues because I have multiple contacts both boxes, and need each time their name appears to count towards their total projects.

Ultimately need everything to go to the dashboard -

Any help would be so appreciative - currently using this formula and has you can see Andrew is still blank -


Answers