COUNTIFS? SUMPRODUCT? Not sure how to count when requiring multiple criteria to be true

Hello,

This is a watered down example of the type of calculation I am trying to get working for simplicity for my question here. I need to count the number of cells that match a few different values in each row(in this example case they can be "accepted" or "requested"), but only if they match the correct type in the columns (Mgr, Staff, Trainee). I am trying to get the formulas for the counts on the left side to function. I have tried many different iterations of COUNTIFS(), SUM(COUNTIFS()), SUMPRODUCT(), etc. I always end up either with errors or double counting or only matching on partial dependencies, etc. Any help would be greatly appreciated as I was trying to just come up with a simple, quick way to do some preliminary scheduling before putting things in our ridiculously unfriendly scheduling application that does not make later changes easy. But, this has ended up wasting a lot of my time trying to make work and is becoming counter productive

Thanks ahead of time for any assistance to get those first three columns counting employees available by position properly.


example.PNG

logic is: IF value="accepted" or "requested" AND person is Mgr THEN increment Mgr count for that row
IF value="accepted" or "requested" AND person is Staff THEN increment Staff count for that row
IF value= anything else (i.e. busy in this example) do nothing

have a look of the attached file

Wow... Ok I had no idea about "shift-control-enter". It almost works as array formula... it only hits on "accepted" but not "requested". It seems to only pay attention to the first possible option ( in this case "accepted").