if, sumif or countif?

  • Thread starter Thread starter Baffin Shea
  • Start date Start date
B

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
 
Baf,

How bout:

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

Earl Kiosterud
mvpearl omitthisword at verizon period net
 
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
Click to expand...

=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
 
Thank you very much.


Earl Kiosterud said:
Baf,

How bout:

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

Earl Kiosterud
mvpearl omitthisword at verizon period net
Click to expand...
 
Thank you very much.


Ron Rosenfeld said:
=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
Click to expand...
 
Back
Top