View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ROland ROland is offline
external usenet poster
 
Posts: 72
Default COUNT IF A VALUE FALLS WITHIN A RANGE IN A SINGLE CELL

example:
H/S 100's 50's 200's 300's 400's
57 1
is there a formula that can automatically sort the figure under H/S into the
respective groupings, e.g 57 would fall under 50's. return that figure also
as 1 as illustrated above.