I am stumped on how to do the following:
I have a set of resources (programmers) and I want to see how many work packages they have assigned per sprint for load balancing purposes. I have a primary and secondary programmer for most packages. In the spreadsheet I have the packages, the programmers, an X for the sprints that they will do the work in. I also have in same spreadsheet the names of the programmers and I want to compute the number of packages they are working per sprint. The goal is that be 1 per sprint. I cannot come up with a formula for it. Here is a manual depiction. Note that I want to compute the loadings automatically.

Package Prim Second Sprint1 Sprint2 Sprint3
wp1 ProgA ProgC X X
wp2 ProgB X
wp3 ProgD ProgA X X


ProgA 1 2 1
ProgB 0 1 0
ProgC 1 1 0
ProgD 0 1 1