I have the following table:

People Jack Jill Fred
Role
Service P B
Support P B
Service C
Operations B P
Operations B C P

I need a function that can sum the number of each (P, B or C) for Role and
People given P = 3, B = 2, C = 1.

Role Sum by People

Role Service Support Operations
People
Jack
Jill 2 3 3
Fred

(Note, I only show Jill's Sum of Roles)

Any help would be appreciated. I am open to replacing P, B and C with 3, 2
and 1. Just need the formula to do the trick.