Quote Originally Posted by xld
I cannot see wht you would copy down, you only need a single count.
No. That Counts all those with values <=-100%

I also need those
<=-90%
<=-80%
<=-70%

All the way through +100 %

So inorder to get those between -100% and -90% I would need to calculate

(Those <=-90%) - (Those <=-90%)

You dig?

I would use SUMIF here.
Ok. I had already used SUMPRODUCT before you posted this and it works. Is there a performance penalty?

Actually, I don't see how to use SUMIF here. The range sizes are not equal.

How do I tell it I want the total of all cells in 'Y' whose row number = row number in 'X' that contains "T" ?