Complicated Array Formula

Hello,

I am working on a project setting up a roll up of data between requirements for projects and available staffs' skill sets. The data is set up in a slightly awkward way, but this analysis will have to be repeated many times and the data will always come in this format. I created a sample, attached. The sample contains the method for analysis and output section. I believe a complicated array is required, but cant make it run properly. If anyone can make it work, I'd appreciate it.

Thank you,

I got different results to XLent with this, in N3, then fill down and drag right.

=SUMPRODUCT(($A$15:$A$17=K3)*(N(LOOKUP($B$15:$F$17,{"High","low","Medium","None"},{3,1,2,0}))<N(LOOKUP($B3:$F3,{"High","low","Medium","None"},{3,1,2,0}))))

To simplify the formula, I've assumed that the Workstream and Staff tables will both contain the same columns in the same order.
Also that the results matrix will have the same rows in the same order as the Workstream table.

Yes, first calc aggregates the "span" of the deficits whereas second, I believe, counts the deficit instances, so you should be covered either way !

Cheers
D.O.

I was looking for XLent's solution, but the way Jason maneuvered the tables is quite clever as well. Fairly awesome that both of you were able to come up with what you did given what you started with.

Thank you,