I considered that approach....but...
If decimals can be in the list, it needs tweaking.
Values between 79 and 80, exclusive, trip it up.
(eg 79.5)

Perhaps:
=INDEX(FREQUENCY(E3:E150,{89,79.9999999999999}),)

--------------------------
Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)


"T. Valko" wrote in message
...
Just to be different:

=INDEX(FREQUENCY(E3:E150,{89,79}),)

--
Biff
Microsoft Excel MVP


"pokdbz" wrote in message
...
I would like to do a count if a value is within a range like
=COUNTIF(E3:E150,"<=89 and =80")

But that doesn't work