Excel 2016: Advanced Formula Help

[ajay_gajree]

Primary Key           Project Code          Issue         Rating
123456                  AB1                       1                B1
123456                  AB1                       1               N/A
123456                  AB1                       2                B1

       1    2
A
B

COUNTIFS(Primary Key,$AB$2,Rating,$AF37&AH$35)

Right this is tricky one, want a formula that will count the unique project code in the top table

I need to repeat the formula in the cells in the 2nd table so that the number of unique projects only appears in the cell that matches the reference in the last column in the top table
So in this case I want the value 1 in the 2nd table in cell B1 only as hat is the value in the fourth column in the first table

I tried the formula above but that gives me two rather 1 as I am unsure how to incorporate the project code unique requirement

Probably as clear as mud

Any help appreciated