A set of 2 critera that can be taken together as an interval...

=COUNTIF(X58:X73,""&Y2)-COUNTIF(X58:X73,"="&Z2)

where Y2 <= Z2 like with 23 and 31, repectively, we get a count of
numbers that fall in the interval specified by " 23 and < 31".

John F wrote:
Excel 2003
Looking for a function that will handle:
Count AND a range of criterea

Something like:
=COUNTIF(X58:X73,"23 & <31")
=COUNTIF(X58:X73,"30,<58")
=COUNTIF(X58:X73,"56,<73")
(but this doesn't work)

any ideas?
Thanks