Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count the number of times a cell value is within a specific range
I am looking for a formula that will count the number of times a specific
task (in column J) occurs within a given time range (in column E). Example, how many times does "A" occur between 0800 hrs. and 0900 hrs. I also need a second formula that sorts the above for each employee. The times are currently being inputed as a number 0800, 0812, etc and not actually military times. Thanks for any assistance I may get. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count the number of times a cell value is within a specific range
try using sumproduct
=sumproduct((rngAcriteria)*(rngA<criteria)) -- Don Guillett SalesAid Software "Everett" wrote in message ... I am looking for a formula that will count the number of times a specific task (in column J) occurs within a given time range (in column E). Example, how many times does "A" occur between 0800 hrs. and 0900 hrs. I also need a second formula that sorts the above for each employee. The times are currently being inputed as a number 0800, 0812, etc and not actually military times. Thanks for any assistance I may get. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count the number of times a cell value is within a specific ra
That did not help.
Let me further explain what I am trying to accomplish. I am a crime scene investigator. Investigators take various calls, such as assaults. The receive the calls at various times throught the day. I am trying to count the number of times the entire unit responded to an assault call between 0800 hrs. and 0900 hrs. I then want to count the number of times an individual investigator took the same call between 0800 hrs. and 0900 hrs. There are 26 different types of calles we respond to through out the day. The types of calls are in column J. The times I am wanting to use in the counting criteria are in column E. Everett "Don Guillett" wrote: try using sumproduct =sumproduct((rngAcriteria)*(rngA<criteria)) -- Don Guillett SalesAid Software "Everett" wrote in message ... I am looking for a formula that will count the number of times a specific task (in column J) occurs within a given time range (in column E). Example, how many times does "A" occur between 0800 hrs. and 0900 hrs. I also need a second formula that sorts the above for each employee. The times are currently being inputed as a number 0800, 0812, etc and not actually military times. Thanks for any assistance I may get. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count the number of times a cell value is within a specific ra
This may also help
Problem 1: Column E Column J 0923 Assault 0945 ADW 1159 Assault 0901 Assault How many "Assault" calls were there between 0900 and 1000? Problem2: Column B Column E Column J Bill 0923 Assault Jim 0945 ADW Bill 1159 Assault Adam 0901 Assault How many "Assault" calls did Bill take between 0900 hrs. and 1000 hrs.? "Don Guillett" wrote: try using sumproduct =sumproduct((rngAcriteria)*(rngA<criteria)) -- Don Guillett SalesAid Software "Everett" wrote in message ... I am looking for a formula that will count the number of times a specific task (in column J) occurs within a given time range (in column E). Example, how many times does "A" occur between 0800 hrs. and 0900 hrs. I also need a second formula that sorts the above for each employee. The times are currently being inputed as a number 0800, 0812, etc and not actually military times. Thanks for any assistance I may get. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I count the number of times a letter is used in a cell? | Excel Discussion (Misc queries) | |||
Count Specific word in specific range | Excel Worksheet Functions | |||
how to format only a specific character or number in each cell withina range of cells | Excel Worksheet Functions | |||
Match function...random search? | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |