Posted to microsoft.public.excel.worksheet.functions
|
|
How to differentiate groups of numbers
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
|