Spreadsheet: 773685d1648000332-need-sum-based-on-duplicate-ids-sum-of-values-based-on-duplicate-ids-updated-
Sheet: Data

Year | Week | ID | agent name | completion status | Missed call | Accepted call | Declined call | Date | Time |  |  | Status as per ID
2022 | 10 |  |  | Completed | 0 | 0 | 0 | 2022-03-06 00:00:00 | 0:34:34 |  |  | In Que
2022 | 10 |  | AG | Completed | 0 | 0 | 0 | 2022-03-07 00:00:00 | 17:25:46 |  |  | In Que
2022 | 10 |  | AG | Agent missed | 1 | 0 | 0 | 2022-03-09 00:00:00 | 12:30:42 |  |  | Missed
2022 | 10 |  | BC | Agent missed | 1 | 0 | 0 | 2022-03-08 00:00:00 | 16:15:50 |  |  | Missed
2022 | 10 |  | BC | Completed | 0 | 0 | 0 | 2022-03-08 00:00:00 | 16:28:21 |  |  | In Que
2022 | 10 |  | DY | Agent missed | 1 | 0 | 0 | 2022-03-08 00:00:00 | 7:26:30 |  |  | Missed
2022 | 10 |  | G | Completed | 0 | 1 | 0 | 2022-03-07 00:00:00 | 3:06:16 |  |  | Completed
2022 | 10 | 1606437 |  | Completed | 0 | 0 | 0 | 2022-03-06 00:00:00 | 0:18:27 |  |  | In Que
2022 | 10 | 1606437 | DY | Completed | 0 | 1 | 0 | 2022-03-06 00:00:00 | 0:18:52 |  |  | Completed
2022 | 10 | 1606441 |  | Completed | 0 | 0 | 0 | 2022-03-06 00:00:00 | 0:24:58 |  |  | In Que
2022 | 10 | 1606442 |  | Completed | 0 | 0 | 0 | 2022-03-06 00:00:00 | 0:25:57 |  |  | In Que
2022 | 10 | 1606443 |  | Completed | 0 | 0 | 0 | 2022-03-06 00:00:00 | 0:25:19 |  |  | In Que
2022 | 10 | 1606443 | DY | Completed | 0 | 1 | 0 | 2022-03-06 00:00:00 | 0:28:05 |  |  | Completed
2022 | 10 | 1606589 |  | Completed | 0 | 0 | 0 | 2022-03-06 00:00:00 | 5:02:20 |  |  | In Que
2022 | 10 | 1606589 | DY | Completed | 0 | 0 | 0 | 2022-03-06 00:00:00 | 5:02:49 |  |  | In Que
2022 | 10 | 1606589 | G | Completed | 0 | 1 | 0 | 2022-03-06 00:00:00 | 5:02:58 |  |  | Completed
2022 | 10 | 1606601 |  | Completed | 0 | 0 | 0 | 2022-03-06 00:00:00 | 5:19:53 |  |  | In Que
2022 | 10 | 1606601 | DY | Completed | 0 | 1 | 0 | 2022-03-06 00:00:00 | 5:27:12 |  |  | Completed
2022 | 10 | 1606601 | G | Completed | 0 | 0 | 0 | 2022-03-06 00:00:00 | 5:24:29 |  |  | In Que
2022 | 10 | 1607267 |  | Completed | 0 | 0 | 0 | 2022-03-06 00:00:00 | 18:05:17 |  |  | In Que
2022 | 10 | 1607267 | RM | Agent missed | 1 | 0 | 0 | 2022-03-06 00:00:00 | 18:05:42 |  |  | Answered by Other Agent
2022 | 10 | 1607267 | T | Completed | 0 | 1 | 0 | 2022-03-06 00:00:00 | 18:08:39 |  |  | Missed by Other Agent
2022 | 10 | 1607272 |  | Completed | 0 | 0 | 0 | 2022-03-06 00:00:00 | 18:07:18 |  |  | In Que
2022 | 10 | 1607272 | RM | Completed | 0 | 0 | 0 | 2022-03-06 00:00:00 | 18:07:50 |  |  | In Que
2022 | 10 | 1607272 | T | Completed | 0 | 1 | 0 | 2022-03-06 00:00:00 | 18:13:35 |  |  | Completed
2022 | 10 | 1607469 |  | Completed | 0 | 0 | 0 | 2022-03-06 00:00:00 | 22:10:03 |  |  | In Que
2022 | 10 | 1607469 | RM | Agent missed | 1 | 0 | 0 | 2022-03-06 00:00:00 | 22:10:27 |  |  | Answered by Other Agent
2022 | 10 | 1607469 | T | Completed | 0 | 1 | 0 | 2022-03-06 00:00:00 | 22:12:43 |  |  | Missed by Other Agent
2022 | 10 | 1608130 |  | Completed | 0 | 0 | 0 | 2022-03-07 00:00:00 | 13:01:30 |  |  | In Que
2022 | 10 | 1608130 | AC | Completed | 0 | 1 | 0 | 2022-03-07 00:00:00 | 13:02:34 |  |  | Answered by Other Agent
2022 | 10 | 1608130 | RF | Agent missed | 1 | 0 | 0 | 2022-03-07 00:00:00 | 13:02:31 |  |  | Missed by Other Agent
2022 | 10 | 1608130 | TW | Completed | 0 | 0 | 0 | 2022-03-07 00:00:00 | 13:02:00 |  |  | In Que
2022 | 10 | 1612585 |  | Completed | 0 | 0 | 0 | 2022-03-10 00:00:00 | 23:07:47 |  |  | In Que
2022 | 10 | 1612585 | DY | Completed | 0 | 1 | 0 | 2022-03-10 00:00:00 | 23:09:16 |  |  | Missed by Other Agent
2022 | 10 | 1612585 | G | Agent missed | 1 | 0 | 0 | 2022-03-10 00:00:00 | 23:08:09 |  |  | Answered by Other Agent
2022 | 10 | 1612585 | R | Agent missed | 1 | 0 | 0 | 2022-03-10 00:00:00 | 23:08:43 |  |  | Answered by Other Agent
2022 | 11 |  |  | Completed | 0 | 0 | 0 | 2022-03-13 00:00:00 | 0:15:42 |  |  | In Que
2022 | 11 |  | AG | Agent missed | 1 | 0 | 0 | 2022-03-15 00:00:00 | 14:44:56 |  |  | Missed
2022 | 11 |  | M | Completed | 0 | 0 | 0 | 2022-03-13 00:00:00 | 12:44:06 |  |  | In Que
2022 | 11 |  | M | Agent missed | 1 | 0 | 0 | 2022-03-16 00:00:00 | 11:24:44 |  |  | Missed
2022 | 11 |  | O | Agent declined | 0 | 0 | 1 | 2022-03-15 00:00:00 | 20:25:27 |  |  | Declined
2022 | 11 | 1615103 |  | Completed | 0 | 0 | 0 | 2022-03-13 00:00:00 | 0:29:19 |  |  | In Que
2022 | 11 | 1615103 | DY | Agent missed | 1 | 0 | 0 | 2022-03-13 00:00:00 | 0:29:42 |  |  | Completed
2022 | 11 | 1615810 |  | Completed | 0 | 0 | 0 | 2022-03-13 00:00:00 | 16:17:05 |  |  | In Que
2022 | 11 | 1615810 | M | Completed | 0 | 1 | 0 | 2022-03-13 00:00:00 | 16:18:09 |  |  | Missed by Other Agent
2022 | 11 | 1615810 | RM | Agent missed | 1 | 0 | 0 | 2022-03-13 00:00:00 | 16:17:36 |  |  | Answered by Other Agent
2022 | 11 | 1616887 |  | Completed | 0 | 0 | 0 | 2022-03-14 00:00:00 | 14:35:20 |  |  | In Que
2022 | 11 | 1616887 | AG | Completed | 0 | 0 | 0 | 2022-03-14 00:00:00 | 14:36:14 |  |  | In Que
2022 | 11 | 1616887 | AC | Agent missed | 1 | 0 | 0 | 2022-03-14 00:00:00 | 14:36:41 |  |  | Answered by Other Agent
2022 | 11 | 1616887 | B | Completed | 0 | 0 | 0 | 2022-03-14 00:00:00 | 14:35:50 |  |  | In Que
2022 | 11 | 1616887 | E | Completed | 0 | 0 | 0 | 2022-03-14 00:00:00 | 14:36:22 |  |  | In Que
2022 | 11 | 1616887 | M | Completed | 0 | 1 | 0 | 2022-03-14 00:00:00 | 14:37:14 |  |  | Missed by Other Agent
2022 | 11 | 1617213 |  | Completed | 0 | 0 | 0 | 2022-03-14 00:00:00 | 20:19:18 |  |  | In Que
2022 | 11 | 1617213 | BC | Completed | 0 | 1 | 0 | 2022-03-14 00:00:00 | 20:24:19 |  |  | Missed by Other Agent
2022 | 11 | 1617213 | B | Agent missed | 1 | 0 | 0 | 2022-03-14 00:00:00 | 20:19:52 |  |  | Answered by Other Agent
2022 | 11 | 1617213 | R | Agent missed | 1 | 0 | 0 | 2022-03-14 00:00:00 | 20:19:58 |  |  | Answered by Other Agent