Are you entering it as an *array* formula, using CSE?

Also ... Any reason you can't use a non-array option?

=SUMPRODUCT((I$6:I$28=0%)*(I$6:I$28<=67%)*(C$6:C$ 28="Asian"))
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Tobro88" wrote in
message ...

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