Hello all

Just one quick inquiry as I'm struggling with a simple issue.

I have three sum products on my workbook

1) searches for sales ppl whose revenue change (by country, column i,) was > +10%
=SUMPRODUCT(--('Contest Effectiveness 2011'!$I$10:$I$137='Summary 2011'!J$16)*--('Contest Effectiveness 2011'!$P$10:$P$137>K12))

where K12 = +10%
column P = % breakdown

2) searches for sales ppl whose revenue change (by country, column i,) was < -10%
=SUMPRODUCT(--('Contest Effectiveness 2011'!$I$10:$I$137='Summary 2011'!J$16)*--('Contest Effectiveness 2011'!$P$10:$P$137>M12))

where M12 = < -10%
where P = % breakdown


The final and third that im struggling to define is the in between (+0 and +9.99%)???

can someple help me define this one, pls and much appreciated!