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

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

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


=COUNTIF(Range,"1")+COUNTIF(Range,"<-1")

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

A new twist to this same question. All the percentages are mixed in with
cells with straight numbers. She only wants to the count the cells with
%ages.

"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