Spreadsheet: 735610d1623092880-dragging-sumifs-function-through-table-changes-the-array-reference-excelhelp
Sheet: Sheet2

Agent Name | Date | Sum of Duration
Alexis | 04-Jan | 00:30:09
 | 05-Jan | 00:31:10
 | 06-Jan | 00:30:59
 | 07-Jan | 00:32:15
 | 08-Jan | 00:31:52
 | 11-Jan | 00:31:12
 | 12-Jan | 00:33:24
 | 13-Jan | 00:31:41
 | 14-Jan | 00:37:34
 | 15-Jan | 00:40:23
 | 19-Jan | 00:03:39
 | 20-Jan | 00:31:35
 | 22-Jan | 00:31:10
 | 25-Jan | 00:34:01
 | 26-Jan | 00:30:46
 | 27-Jan | 00:52:36
 | 28-Jan | 00:41:50
 | 29-Jan | 00:31:06
 | 01-Feb | 00:43:34
 | 02-Feb | 00:31:33
 | 03-Feb | 00:41:16
 | 04-Feb | 00:31:35
 | 05-Feb | 00:34:37
 | 08-Feb | 00:32:06
 | 09-Feb | 00:31:03
 | 10-Feb | 00:35:51
 | 11-Feb | 00:34:09
 | 12-Feb | 00:33:37
 | 16-Feb | 00:36:27
 | 17-Feb | 00:22:57
 | 18-Feb | 00:24:57
 | 19-Feb | 00:38:44
 | 22-Feb | 00:37:38
 | 23-Feb | 00:31:43
 | 24-Feb | 00:33:05
 | 25-Feb | 00:30:30
 | 26-Feb | 00:31:06
 | 01-Mar | 00:25:23
 | 02-Mar | 00:35:42
 | 03-Mar | 00:47:11
 | 04-Mar | 00:31:38
 | 08-Mar | 00:30:54
 | 09-Mar | 00:32:12
 | 10-Mar | 00:30:53
 | 11-Mar | 00:33:12
 | 15-Mar | 00:42:26
 | 16-Mar | 00:30:50
 | 17-Mar | 00:32:12
 | 18-Mar | 00:33:47
 | 19-Mar | 00:31:13
 | 22-Mar | 00:34:45
 | 23-Mar | 00:53:52
 | 24-Mar | 00:31:36
 | 26-Mar | 00:32:51
 | 29-Mar | 00:35:49
 | 30-Mar | 00:31:18
 | 31-Mar | 01:01:02
 | 01-Apr | 00:31:31
 | 02-Apr | 00:33:16
 | 09-Apr | 00:35:10
 | 12-Apr | 00:35:47
 | 13-Apr | 00:30:54
 | 14-Apr | 00:31:36
 | 15-Apr | 00:39:10
 | 16-Apr | 00:31:27
 | 19-Apr | 00:24:14
 | 20-Apr | 00:26:03
 | 21-Apr | 00:47:00
 | 22-Apr | 00:24:07
 | 23-Apr | 00:25:02
 | 26-Apr | 00:37:20
 | 27-Apr | 01:00:06
 | 28-Apr | 00:32:23
 | 29-Apr | 00:31:16
 | 30-Apr | 00:19:11
 | 03-May | 00:43:29
 | 04-May | 00:28:24
 | 06-May | 00:33:13
 | 07-May | 00:47:27
 | 10-May | 00:31:50
 | 11-May | 00:35:16
 | 12-May | 00:34:19
 | 13-May | 00:36:42
 | 14-May | 00:47:42
 | 17-May | 00:53:20
 | 18-May | 00:35:20
 | 19-May | 00:31:26
 | 20-May | 00:58:09
 | 21-May | 00:32:03
 | 24-May | 00:28:46
 | 26-May | 00:33:48
 | 27-May | 00:13:36
 | 28-May | 00:41:11
Alexis Total |  | 1900-01-02 05:24:10
[NAME] | 05-Jan | 00:39:15
 | 06-Jan | 00:30:07
 | 12-Jan | 00:33:00
 | 13-Jan | 00:34:25
 | 14-Jan | 00:36:55
 | 15-Jan | 00:30:47
 | 19-Jan | 00:38:10
 | 20-Jan | 00:31:19
 | 21-Jan | 00:33:56
 | 22-Jan | 00:36:43
 | 27-Jan | 00:33:09
 | 28-Jan | 00:34:18
 | 29-Jan | 00:35:16
 | 01-Feb | 00:35:04
 | 02-Feb | 00:35:19
 | 03-Feb | 00:15:59
 | 04-Feb | 00:30:35
 | 05-Feb | 00:34:20
 | 08-Feb | 00:31:08
 | 09-Feb | 00:30:46
 | 10-Feb | 00:31:24
 | 11-Feb | 00:34:55
 | 12-Feb | 00:33:32
 | 16-Feb | 00:33:30
 | 18-Feb | 00:30:48
 | 19-Feb | 00:34:09
 | 22-Feb | 00:31:08
 | 24-Feb | 00:31:29
 | 25-Feb | 00:30:27
 | 26-Feb | 00:33:18
 | 01-Mar | 00:32:22
 | 02-Mar | 00:31:41
 | 03-Mar | 00:42:40
 | 05-Mar | 00:36:36
 | 08-Mar | 00:30:32
 | 09-Mar | 00:30:08
 | 10-Mar | 00:30:39
 | 11-Mar | 00:18:01
 | 15-Mar | 00:37:05
 | 16-Mar | 00:17:00
 | 18-Mar | 00:39:47
 | 19-Mar | 00:32:39
 | 22-Mar | 00:30:23
 | 23-Mar | 00:35:28
 | 24-Mar | 00:30:14
 | 25-Mar | 01:33:07
 | 26-Mar | 00:31:12
 | 29-Mar | 00:30:45
 | 30-Mar | 00:30:44
 | 31-Mar | 00:36:01
 | 01-Apr | 00:33:53
 | 02-Apr | 01:35:50
 | 05-Apr | 00:30:05
 | 06-Apr | 00:15:05
 | 07-Apr | 00:31:34
 | 08-Apr | 00:35:06
 | 12-Apr | 00:30:59
 | 14-Apr | 00:35:15
 | 15-Apr | 00:31:46
 | 16-Apr | 00:35:20
 | 19-Apr | 00:30:41
 | 20-Apr | 00:30:05
 | 21-Apr | 00:30:25
 | 22-Apr | 00:36:42
 | 23-Apr | 00:30:33
 | 26-Apr | 00:30:21
 | 28-Apr | 00:34:37
 | 29-Apr | 00:31:34
 | 30-Apr | 00:34:17
 | 03-May | 00:36:23
 | 04-May | 00:30:34
 | 05-May | 00:34:16
 | 06-May | 00:30:24
 | 07-May | 00:20:08
 | 10-May | 00:30:06
 | 11-May | 00:32:04
 | 13-May | 00:30:26
 | 14-May | 00:30:11
 | 17-May | 00:35:34
 | 18-May | 00:32:38
 | 19-May | 00:15:13
 | 21-May | 00:36:25
 | 24-May | 00:34:15
 | 25-May | 00:30:40
 | 26-May | 00:02:44
 | 27-May | 00:34:57
 | 28-May | 00:34:52
[NAME] |  | 1900-01-01 23:58:13
Grand Total |  | 1900-01-04 05:22:23