Thanks ALL:
I'll try each method so it will hopefully drill in my head somewhere.
I'll have to come back after supper to try them out.

The prompt response is greatly appreciated.
John F.

"Aladin Akyurek" wrote:

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