counting negative and positive percentages in a column

[vieux-loup64]

I am trying to figure out how to do a sumif or countif for a range of
values negative and positive values of a cell in a column.

example

10%
15%
33%
-10%
-5%
-45%

I would like to have one formula to count the cells with a positive %
from 0.01% to 20%
another formula to count the cells with a negative % from -0.01% to
-20%

thank you

 

[T. Valko]

Try these:

For the positive range:

=COUNTIF(A1:A10,">=0.01%")-COUNTIF(A1:A10,">20%")

For the negative range:

=COUNTIF(A1:A10,"<=-0.01%")-COUNTIF(A1:A10,"<-20%")

 

[Shane Devenshire]

Hi,

In 2003 and earlier you can use:

=SUMPRODUCT((A1:A9>=0.01)*(A1:A9<=0.2))
=SUMPRODUCT((A1:A9>=-0.2)*(A1:A9<=-0.01))

In 2007:

=COUNTIFS(A1:A9,">=-.2",A1:A9,"<=-.01")
=COUNTIFS(A1:A9,">=.01",A1:A9,"<=.2")

If this helps, please click the Yes button.