=SUMPRODUCT(SIGN((APR'!$A$3:$A$2500&APR'!$B$3:$B$2500="Place holder"&$B$2)*(APR'!$I$3:$I$2500<>"R")))

for the most part this formula works but in Collumn "I" I want to exclude Value "R", the problem is it is also excluding the value RBS which I don't want.

This has to be a sumproduct formula as it is referencing a closed workbook (I have shortened it for easy viewing removing the file location path)

Any Help will be much appreciated