Greater than # but less than #

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ph3nom3nalwoman - 26 May 2008 20:22 GMT

I want to do a count of how many #'s are between this %range (ex <=80%, <+99)
I am not having any luck doing this. Any help would be great!
thanks

Signature

PH3

Reply to this Message

Ragdyer - 26 May 2008 20:45 GMT

I'll assume you really mean,
greater then or equal to 80%
and
less then or equal to 99%

With data in A1 to A50,

try one of these:

=Countif(A1:A50,">=80%")-Countif(A1:A50,">99%")

OR

=Sumproduct((A1:A50>=80%)*(A1:A50<=99%))

Signature

HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

> I want to do a count of how many #'s are between this %range (ex <=80%, <+99)
> I am not having any luck doing this. Any help would be great!
> thanks

Reply to this Message

Gary''s Student - 26 May 2008 20:46 GMT

In cell B1 enter:
=COUNTIF(A:A,"<.99")-COUNTIF(A:A,"<0.8")
so if column A had:

0.8
0.85
0.98
0.999
0.7

the formula gives back 3

Signature

Gary''s Student - gsnu200789

> I want to do a count of how many #'s are between this %range (ex <=80%, <+99)
> I am not having any luck doing this. Any help would be great!
> thanks

Reply to this Message

Rick Rothstein (MVP - VB) - 26 May 2008 20:47 GMT

Your example does not define a range (or at least not the kind I think you
are looking for) as they both specify less than type conditions. Also, one
is a percentage and the other is not. However, if you have a range such as

>=2 and <9, you could use this to count it...

=SUMPRODUCT((A1:A10>=2)*(A1:A10<9))

Just change the 2 and 9 values and the logical operator combinations to
match your requirements.

Rick

>I want to do a count of how many #'s are between this %range (ex <=80%,
><+99)
> I am not having any luck doing this. Any help would be great!
> thanks

Reply to this Message