Thank you for the feedback.

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"RodJ" wrote in message
...
Fantastic...this worked beautifully...awesome....thanks..
--
RodJ


"Ashish Mathur" wrote:

=countif(range,"<22") and =countif(range,"22")

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"RodJ" wrote in message
...

eg: number group = 2,12,18,35,36,40. I need a function that will tell
me
how
many numbers are under 22 and how many are over 23.
Answer I am looking for is:
Under 22 = 3
Over 22 = 3.

Is there a function that can give me this answer. Thanks
--
RodJ