Counting items by attributes

Hi,
I've got some problems to solve one case, to be honest I'm struggling with this issue since few days and have no more ideas, maybee because of the fact that I'm excel beginer.

Anyway, maybe somebody will have any ideas about that.

Problem description:
I've got staff list. Each particular person has some priviliges (marked from A to J) or no priviliges. There is no any rule how many priviliges one person may have maximally or minimally, so it means that e.g. Person AA may have 4 different priviliges, person BD 2 priviliges, person CC no priviliges.

I would like to create a calculator which will show defficiencies or surpluses of personnel basing on staff list analyze. The problem is that there are 89 persons availible and 9 types of priviliges. How to count defficiencis or surpluses in this case? Especially when e.g. person AA who has priviliges A,B,C,F can be used only to cover demand for one of privilige he has, for example A and I cannot use this person to cover demand for B,C,F.

I tried to set some conditions in order to get an optimum solution, however it's not so easy, that's why I decided to open a new topic. I think that setting the priorites for priviliges types is a must, otherwise there will be few solutions.

If anybody has any idea how to solve my problem or can give me any tips, I would like to thank You in advance. Maybe Solver mabye some macros, I don't know.

I'm attaching simplified sheet showing the problem.
Unfortunately, I'm not a native speaker, however I hope that I described my problem in understandable way.
Brgds, Peter