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