Works okay for me in a small test.Try reducing the number of rows, and
increase until you get an error, then check the data.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Teri" wrote in message
...
I have the current formula:


=SUMPRODUCT(--($A$1:$A$2500="CLE"),--($B$1:$B$2500="IE"),--($E$1:$E$2500=6),
--($I$1:$I$2500<0))

which works perfectly. Now I want to find out the number of times a value
less than 20% appears in column J. Why won't this work when I change the
formula so the ending argument is
,--($J$1:$J$2500<.20)) ??

I keep getting a #DIV/0 error!