| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count based on multiple criteria
I have multiple sheets. One sheet identifies the date a ticket was closed
and the ID of the technician that closed the ticket. Open Dt Closed Dt ID 04/22/09 06/05/09 JM44 04/17/09 06/05/09 X72Z 04/17/09 06/05/09 X72Z 05/21/09 06/05/09 X72Z 05/22/09 06/05/09 X86D 04/28/09 06/08/09 CG52 01/12/09 06/08/09 HD54 05/07/09 06/08/09 TBD 06/05/09 06/08/09 TBD 04/17/09 06/10/09 HD54 The second worksheet contains each week of the month/year. I need a formula that calculates the number of tickets that were closed by tech id based on the closure date and a week range. Week # Clsd CG52 # Clsd JM44 # Clsd X72Z 06/01/2009 - 06/07/09 1 3 06/08/2009 - 06/14/09 1 Thanks in advance to anyone that can help me with this. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count based on multiple criteria | Excel Worksheet Functions | |||
| Count based on multiple criteria | Excel Discussion (Misc queries) | |||
| Count based on multiple criteria | Excel Worksheet Functions | |||
| Count based on multiple criteria | Excel Worksheet Functions | |||
| How do I get the count in excel based on criteria in multiple col | Excel Worksheet Functions | |||
Threaded Mode
