Countif Match- multiple values issue

I have done something similar, but I keep getting stuck on this. I appreciate any assistance. What I am attempting to do in this workbook is:
In M8 for it to count D8:D10 if A8:A10 matches L8 and only if that matches M7. Basically I have a data log manual entry on the left and I want the section on the right (in this example) to look to the data entered and say Andfel Laureano has 4 Miss Picks. It would not count the next error he has because it is not a miss pick.

I only need help with the one formula. I can make all the adjustments as I alter this sheet to be more user friendly. Thanks again for any assistance as I have been stuck on this for awhile. I seem to always get 3/4 of the way there. I run into the Miss Pick match problem.

If its just COUNT use

In M8
=COUNTIFS($A$8:$A$10,$L8,$E$8:$E$10,M$7)
Copy down and across

If you want a sum of # of errors use
=SUMIFS($D$8:$D$10,$A$8:$A$10,$L8,$E$8:$E$10,M$7)
Copy down and across

Try this in M8. copy across & down.

=SUMIFS($D$8:$D$10,$A$8:$A$10,$L8,$E$8:$E$10,M$7)