View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers
 
Posts: n/a
Default counting occurences in data range (e.g 31-60)

one way:

=Sumproduct((range1=condition1),(range1<=conditio n2))

"Chuck" wrote:

I am having difficulty in coming up with the correct function to count
occureneces within a given range of data. For example, if spreadsheet cells
F5:F20 are pure numbers representing the days to process individual request,
I am trying to determine the number of occurence for time that it take from
30-60 days to process the requests.