if, sumif or countif?

[Baffin Shea]

dear all,

can anyone help? if the cell A0-A100 is an array of percentage number, and i
would like to have a function at cell A102 in order to calculation the
number of percentage between 20%-30%, how can i do that?

thank you.

baf

 

[Earl Kiosterud]

Baf,

How bout:

=SUMPRODUCT((A1:A100>=20%)*(A1:A100<=30%))

Earl Kiosterud
mvpearl omitthisword at verizon period net

 

[Ron Rosenfeld]

dear all,

can anyone help? if the cell A0-A100 is an array of percentage number, and i
would like to have a function at cell A102 in order to calculation the
number of percentage between 20%-30%, how can i do that?

thank you.

baf

=COUNTIF(A1-A100,">0.2") - COUNTIF(A1-A100,">0.3")

Notes: There is no cell address A0
Depending on what you mean by "between", you may need to change one or
both of the ">" to ">=".


--ron

 

[Baffin Shea]

Thank you very much.

Baf,

How bout:

=SUMPRODUCT((A1:A100>=20%)*(A1:A100<=30%))

Earl Kiosterud
mvpearl omitthisword at verizon period net

 

[Baffin Shea]

Thank you very much.

=COUNTIF(A1-A100,">0.2") - COUNTIF(A1-A100,">0.3")

Notes: There is no cell address A0
Depending on what you mean by "between", you may need to change one or
both of the ">" to ">=".


--ron