View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kippers kippers is offline
external usenet poster
 
Posts: 51
Default Counting numbers greater or less than a number

How can I count the total number of cells (around 2000 rows worth) that are
less than or equal to a set of numbers (i.e. 5 and <10)?

Have been using the COUNT and COUNTIF functions and summing them up but this
obviously takes all cases greater than 5 and ALL cases below 11 (and hence
below 5) which distorts the result??

Any ideas welcome!!

Cheers