View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AJ AJ is offline
external usenet poster
 
Posts: 99
Default Look up value range in column and then count

I have a column of numbers ranging from 0 to -100
I need to count the number of cells with in the ranges
0 to -6
-7 to -14
-15 to -28
-85 to -100

Can you tell me the best way to get these figures, I would imagine I have to
put this formula into 4 different cells.
Thanks AJ