Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count based on multiple criteria
Hi,
You could use a pivot table. Drag date and user ID to the row area, drag user id once again the data area (to get the count). Now click on any cell in the date column and on the pivot table toolbar, go to Group and Show detail Group Days Type 7 in the box -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "birdey" wrote in message ... I have a workbook that has multiple worksheets. On one worksheet ('Chart Details') I have the following. Column A represents the date that a ticket was closed and Column B indicates that userid of the technician that closed the ticket. I need a formula that will calcluate the number of closed tickets by technician by week. On the other worksheet ('Chart Data') I have to reflect how many tickets each technician closed per week (e.g., 06/01/09 - 06/07/09, 06/08/09 - 06/14/09, etc.) A B 2 06/01/09 CG52 3 06/02/09 CG52 4 06/05/09 X72Z 5 06/06/09 HD54 6 06/08/09 CG52 7 06/10/09 X72Z 8 06/11/09 CG52 9 06/11/09 X72Z So, my formula I need to reflect the following Week UserID # of Closed tickets 06/01/09 - 06/07/09 CG52 2 06/01/09 - 06/07/09 X72Z 1 06/01/09 - 06/07/09 HD54 1 06/08/09 - -6/14/09 X72Z 2 06/08/09 - -6/14/09 CG52 2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 | |||
count based on multiple date criteria | Excel Worksheet Functions |