maryj,

Try

=COUNTIF(D17:D21,"=1") + COUNTIF(D17:D21,"<=-1")

----
Regards,
John Mansfield
http://www.pdbook.com

"maryj" wrote:

I have a client that needs to count the number of values in a range that are
either greater than 100% or less than -100%. I'm assuming that we would need
to use some type of sumproduct.

Thanks for your help.

maryj