Thread: How to differentiate groups of numbers
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
  
Posts: 1,766
Default How to differentiate groups of numbers
=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

Reply With QuoteReply With Quote