Greater than # but less than #

  • Thread starter Thread starter ph3nom3nalwoman
  • Start date Start date
P

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
 
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%))
 
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
 
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...
Click to expand...

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

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

Rick
 
Back
Top