Greater than # but less than #

[ph3nom3nalwoman]

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

 

[Ragdyer]

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%))

 

[Gary''s Student]

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

 

[Rick Rothstein \(MVP - VB\)]

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