SUMPRODUCT Formula to exclude a criteria but include a similar criteria

[insanebe]

=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

 

[Mike LH]

Hi,

That formula shouldn't exclude RBS, it will only exclude an upper or lower case R so something else is wrong, can we see some data?

 

[insanebe]

Hi,

That formula shouldn't exclude RBS, it will only exclude an upper or lower case R so something else is wrong, can we see some data?

Thank you, it was a data entry instead of "placer holder" it said place "holdrr" on the main data table

now I feel stupid, thank you anyway.