| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting occurences in data range (e.g 31-60)
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Range Mess | Charts and Charting in Excel | |||
| How can you sum the last 5 columns of data from a range of data | New Users to Excel | |||
| Data Validation range | Excel Discussion (Misc queries) | |||
| Pivot Table - max rows allowed in data range | Excel Discussion (Misc queries) | |||
| data range props | Excel Discussion (Misc queries) | |||
Linear Mode
