|
|
|
|
Thanks!
"John Mansfield" wrote:
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
|