View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Buffalo Buffalo is offline
external usenet poster
 
Posts: 2
Default Counting Numbers

I have a list of numbers I want to know how many fall into a certain range.
Is there a way to count them?

EX:

A 12
B 15
C 16
D 2
E 100

now I would like to know how many fall between 10 and 20, is there a
function? something like =countif(A1:E1, 1020) just an example! thanks