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

=COUNTIF(F5:F20,"=30")-COUNTIF(F5:F20,"=60")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Chuck" wrote in message
...
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.