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