Counting Using Multiple Criteria

[MVRincon]

I am trying to count using multiple criteria. I've have a Data Set and I need to count the number of entries outside the target bounds.

I've tried:

• =SUMPRODUCT(('OTR Results'!E3:E3000=Suppliers!F6))*('OTR Results'!N3:N3000>'OTR Results'!F3:F3000) + SUMPRODUCT(('OTR Results'!E3:E3000=Suppliers!F6))*('OTR Results'!N3:N3000>'OTR Results'!F3:F3000)
• =COUNTIFS('OTR Results'!$E$3:$E$3000,$J6, 'OTR Results'!$N$3:$N$3000, ">=" &($J6*0.9), 'OTR Results'!$N$3:$N$3000, "<=" &($J6*1.1))
• =SUMPRODUCT(('OTR Results'!$E$3:$E$3000=Suppliers!$F15) * ('OTR Results'!$N$3:$N$3000 > (Suppliers!$F15*0.9)) * ('OTR Results'!$N$3:$N$3000 < (Suppliers!$F15*1.1)))

On the arrays, I used clt + shift + enter and made sure the "{}" marks were there.

I have put too many hours into trying this and any help would be much appreciated. File attached.

Thank you,

[gak67]

What about the countifs in your sample sheet is not correct?