I was wondering if anyone could help me with an error when I try to
count scores that fall between a 0% - 67% range. If I leave it as 0%
it does not count the cell. If I change the formula to 0.1% - 67% then
it counts it. Any ideas?

Here is the array in question:
=SUM((I$6:I$28=0.1%)*((I$6:I$28<=67%)*((C$6:C$28= "Asian"))*1))

I need it to accept the 0.1% as 0%.

Thanks,
Tobro


--
Tobro88
------------------------------------------------------------------------
Tobro88's Profile: http://www.excelforum.com/member.php...o&userid=28895
View this thread: http://www.excelforum.com/showthread...hreadid=490591