Problems with SUMPRODUCT -Need help badly!!

Hi all, this is driving me mad and I know one of you kind soles will come to my rescue!!

I am trying to calculate using SUMPRODUCT in order to get results from 2 columns. The first column shows the test priority (column D) and the second shows the result (column E). There are 4 levels of priority - Critical, high, medium, low and 6 results - 1 and 2 is fail, 3 is Quality Issue, 4 and 5 are pass and 'pending' is not yet carried out.

In the matrix table, I want to show The number of tests per category, ie. That x amount of critical tests have passed, y have failed, z are pending and so on and so forth.

I am looking forward to your expert advice and thank you in advance.

Cheers