View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RodJ RodJ is offline
external usenet poster
 
Posts: 11
Default How to differentiate groups of numbers


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