View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SSM SSM is offline
external usenet poster
 
Posts: 3
Default Counting number of instances in a range

My worksheet is like this:
A1 A2...
120 210 333 400 510 625 789 801 ...10000

How can I get the how many of the cells the cells have a value between 0 and
400 (in the question above 4), how many times the cells have a value between
401 and 800 (3), etc.?

Thanks in advance...

Regards,
SSM