Greater than # but less than #
 

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
--
PH3

Greater than # but less than #
 

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"ph3nom3nalwoman" wrote in
message ...
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
--
PH3

Greater than # but less than #
 

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
--
Gary''s Student - gsnu200789


"ph3nom3nalwoman" wrote:

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
--
PH3

Greater than # but less than #
 

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


"ph3nom3nalwoman" wrote in
message ...
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
--
PH3