counting occurences in data range (e.g 31-60)

C

Chuck

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.
 
B

Bob Phillips

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

--
HTH

Bob Phillips

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