Spreadsheet: 737735d1624557866-need-sum-total-of-categories-per-interval-based-on-agent-schedules-and-their-categories-excelhelp
Sheet: Sheet1

 |  |  |  | Agent Categories
 |  |  |  | Agent | Category 1 | Category 2 | Category 3 | Category 4 | Category 5 | Category 6 | Category 7 | Category 8 | Category 9
 |  |  |  | Alexis | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  | [NAME] |  | 1 | 1 | 1 | 1 | 1 |  | 1 | 1
 |  |  |  | [NAME] |  | 1 |  |  |  |  |  | 1 | 1
 |  |  |  | Edi |  | 1 |  |  |  |  |  | 1 | 1
 |  |  |  | Brittany |  | 1 |  |  |  |  |  | 1 | 1
 |  |  |  | [NAME] |  | 1 |  |  |  |  |  | 1 | 1
 |  |  |  | Agent Schedule
 |  |  |  | Agent | 05:00:00 | 05:30:00 | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00
 |  |  |  | Alexis | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  | [NAME] |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  | [NAME] |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  | Edi |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  | Brittany |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  | [NAME] |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  | Total Count of Categories per interval
 |  |  |  | Category | 05:00:00 | 05:30:00 | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00
 |  |  |  | Category 1
 | This Table should hold the results |  |  | Category 2
 |  |  |  | Category 3
 |  |  |  | Category 4
 |  |  |  | Category 5
 |  |  |  | Category 6
 |  |  |  | Category 7
 |  |  |  | Category 8
 |  |  |  | EXAMPLE RESULT:
 |  |  |  | Total Count of Categories Per Interval
 |  |  |  | Category | 05:00:00 | 05:30:00 | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00
 |  |  |  | Category 1 | 6 | 6 | 10 | 14 | 18 | 19 | 22 | 25 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 24 | 22 | 21 | 15 | 12 | 8 | 7 | 5 | 6
 |  |  |  | Category 2 | 5 | 5 | 8 | 11 | 12 | 13 | 15 | 18 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 17 | 17 | 17 | 14 | 13 | 10 | 8 | 7 | 6 | 5
 |  |  |  | Category 3 | 5 | 5 | 8 | 11 | 12 | 13 | 15 | 18 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 17 | 17 | 17 | 14 | 13 | 10 | 8 | 7 | 6 | 5
 |  |  |  | Category 4 | 3 | 3 | 6 | 10 | 10 | 10 | 12 | 13 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 14 | 14 | 12 | 11 | 10 | 7 | 5 | 4 | 4 | 3
 |  |  |  | Category 5 | 2 | 2 | 4 | 8 | 8 | 8 | 10 | 11 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 12 | 12 | 11 | 10 | 9 | 7 | 5 | 4 | 4 | 3
 |  |  |  | Category 6 | 1 | 1 | 2 | 6 | 7 | 7 | 8 | 9 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 9 | 9 | 8 | 6 | 4 | 3 | 3 | 2
 |  |  |  | Category 7 | 6 | 6 | 10 | 14 | 18 | 19 | 22 | 25 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 24 | 22 | 21 | 15 | 12 | 8 | 7 | 5 | 5
 |  |  |  | Category 8 | 6 | 6 | 10 | 14 | 18 | 19 | 22 | 25 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 24 | 22 | 21 | 15 | 12 | 8 | 7 | 5 | 5