Spreadsheet: 684046d1593106466-how-to-add-rows-fx-to-a-countifs-fx-so-the-last-factor-updates-vertically-and-horizontally-sample-1-
Sheet: Query

Printer ID | [NAME] | Printer Model | Branch ID | Task name | dateCreated | timeCreated | dateStarted | timeStarted | dateFinished | timeFinished | Tech Duration | Total Duration | createdBy | finishedBy | note | Month
270 | K51_HEXA | Kornit Storm HEXA | 3 | Banding - Cleaning/Purge & Wipe | 2020-04-02 00:00:00 | 09:29:32 | 2020-04-02 00:00:00 | 09:54:16 | 2020-04-02 00:00:00 | 09:54:18 |  |  | [NAME] | [NAME]
435 | K43_HD | [NAME] (Eco) | 3 | Banding - Cleaning/Purge & Wipe | 2020-04-02 00:00:00 | 10:46:39 | 2020-04-02 00:00:00 | 11:35:46 | 2020-04-02 00:00:00 | 11:35:48 |  |  | [NAME] | [NAME]
332 | [NAME] | Kornit Storm HEXA | 3 | Banding - Cleaning/Purge & Wipe | 2020-04-09 00:00:00 | 14:03:45 | 2020-04-09 00:00:00 | 15:56:09 | 2020-04-09 00:00:00 | 15:56:11 |  |  | [NAME] | [NAME]
424 | K44_HD | [NAME] ([NAME]) | 3 | Banding - Cleaning/Purge & Wipe | 2020-04-14 00:00:00 | 07:17:12 | 2020-04-14 00:00:00 | 07:17:15 | 2020-04-14 00:00:00 | 07:17:17 |  |  | [NAME] | [NAME]
590 | [NAME] | [NAME] (Neutra Fix++) | 3 | Banding - Cleaning/Purge & Wipe | 2020-04-15 00:00:00 | 18:43:04 | 2020-04-15 00:00:00 | 21:26:29 | 2020-04-15 00:00:00 | 21:26:31 |  |  | [NAME] | [NAME]
369 | K23_HEXA | Kornit Storm HEXA | 3 | Banding - Cleaning/Purge & Wipe | 2020-04-16 00:00:00 | 15:15:35 | 2020-04-16 00:00:00 | 16:08:18 | 2020-04-16 00:00:00 | 16:08:20 |  |  | Christian Parrales | [NAME]
647 | K20_ATLAS | [NAME] (Neutra Fix++) | 3 | Banding - Cleaning/Purge & Wipe | 2020-04-20 00:00:00 | 16:44:48 | 2020-04-20 00:00:00 | 16:53:18 | 2020-04-20 00:00:00 | 16:53:20 |  |  | [NAME] | [NAME]
590 | [NAME] | [NAME] (Neutra Fix++) | 3 | Banding - Cleaning/Purge & Wipe | 2020-04-20 00:00:00 | 16:58:16 | 2020-04-20 00:00:00 | 18:55:31 | 2020-04-20 00:00:00 | 18:55:33 |  |  | Christian Parrales | [NAME]
375 | K27_HEXA | Kornit Storm HEXA | 3 | Banding - Cleaning/Purge & Wipe | 2020-04-22 00:00:00 | 14:22:00 | 2020-04-22 00:00:00 | 16:27:08 | 2020-04-22 00:00:00 | 16:27:10 |  |  | [NAME] | [NAME]
324 | K31_Hexa | Kornit Storm HEXA | 3 | Banding - Cleaning/Purge & Wipe | 2020-04-07 00:00:00 | 09:45:11 | 2020-04-07 00:00:00 | 19:03:15 | 2020-04-07 00:00:00 | 19:03:18 |  |  | [NAME] | [NAME]
372 | K25_HEXA | Kornit Storm HEXA | 3 | Banding - Cleaning/Purge & Wipe | 2020-04-08 00:00:00 | 23:44:04 | 2020-04-09 00:00:00 | 22:19:53 | 2020-04-09 00:00:00 | 22:19:56 |  |  | [NAME] | [NAME]
590 | [NAME] | [NAME] (Neutra Fix++) | 3 | Banding - Cleaning/Purge & Wipe | 2020-04-15 00:00:00 | 16:03:14 | 2020-04-15 00:00:00 | 16:37:33 | 2020-04-15 00:00:00 | 16:37:36 |  |  | [NAME] | [NAME]
439 | [NAME] | [NAME] ([NAME]) | 3 | Banding - Cleaning/Purge & Wipe | 2020-04-17 00:00:00 | 03:16:29 | 2020-04-17 00:00:00 | 03:49:13 | 2020-04-17 00:00:00 | 03:49:16 |  |  | [NAME] | [NAME]
374 | K26_HEXA | Kornit Storm HEXA | 3 | Other | 2020-05-06 00:00:00 | 23:34:08 | 2020-05-07 00:00:00 | 00:50:54 | 2020-05-07 00:00:00 | 00:50:58 |  |  | [NAME] | [NAME]
178 | KORNIT_5 | Kornit Storm HEXA | 1 | Freezing - Software/Axis Error | 2020-05-07 00:00:00 | 02:47:30 | 2020-05-07 00:00:00 | 05:00:40 | 2020-05-07 00:00:00 | 05:05:25 |  |  | [NAME] | [NAME]
708 | ATLAS_01 | [NAME] | 8 | Unknown | 2020-05-07 00:00:00 | 03:19:27 | 2020-05-07 00:00:00 | 03:19:37 | 2020-05-07 00:00:00 | 03:50:11 |  |  | [NAME] | [NAME]
582 | [NAME] | [NAME] (Neutra Fix++) | 3 | Banding - Cleaning/Purge & Wipe | 2020-05-07 00:00:00 | 03:30:12 | 2020-05-07 00:00:00 | 03:45:16 | 2020-05-07 00:00:00 | 07:29:29 |  |  | Carmen Morales | [NAME]
590 | [NAME] | [NAME] (Neutra Fix++) | 3 | Freezing - Software/Axis Error | 2020-05-07 00:00:00 | 03:55:18 | 2020-05-07 00:00:00 | 04:57:15 | 2020-05-07 00:00:00 | 04:57:19 |  |  | [NAME] | [NAME]
591 | [NAME] | [NAME] (Neutra Fix++) | 3 | Freezing - Software/Axis Error | 2020-05-07 00:00:00 | 04:09:44 | 2020-05-07 00:00:00 | 04:47:21 | 2020-05-07 00:00:00 | 04:47:27 |  |  | [NAME] | [NAME]
443 | [NAME] | [NAME] ([NAME]) | 3 | Spray Coverage | 2020-05-07 00:00:00 | 04:21:33 | 2020-05-07 00:00:00 | 04:27:07 | 2020-05-07 00:00:00 | 04:27:09 |  |  | Patience Ntita | [NAME]
708 | ATLAS_01 | [NAME] | 8 | Unknown | 2020-05-07 00:00:00 | 04:24:06 | 2020-05-07 00:00:00 | 04:24:09 | 2020-05-07 00:00:00 | 05:16:07 |  |  | [NAME] | [NAME]
443 | [NAME] | [NAME] ([NAME]) | 3 | Spray Coverage | 2020-05-07 00:00:00 | 04:29:57 | 2020-05-07 00:00:00 | 05:24:09 | 2020-05-07 00:00:00 | 05:24:12 |  |  | Patience Ntita | [NAME]
439 | [NAME] | [NAME] ([NAME]) | 3 | Data Scramble | 2020-05-07 00:00:00 | 04:35:20 | 2020-05-07 00:00:00 | 08:00:43 | 2020-05-07 00:00:00 | 08:00:46 |  |  | [NAME] | [NAME]
583 | K04_ATLAS | [NAME] (Neutra Fix++) | 3 | Freezing - Software/Axis Error | 2020-05-07 00:00:00 | 04:53:34 | 2020-05-07 00:00:00 | 04:58:08 | 2020-05-07 00:00:00 | 05:49:52 |  |  | Carmen Morales | [NAME]
157 | [NAME] | Kornit Storm HEXA | 3 | Banding - Print Head Change | 2020-05-07 00:00:00 | 05:10:20 | 2020-05-07 00:00:00 | 05:51:14 | 2020-05-07 00:00:00 | 19:46:50 |  |  | [NAME] | [NAME]
145 | KORNIT 1 | Kornit Storm HEXA | 1 | Testing | 2020-05-07 00:00:00 | 05:25:51 | 2020-05-07 00:00:00 | 05:41:26 | 2020-05-07 00:00:00 | 05:41:32 |  |  | [NAME] | [NAME]
178 | KORNIT_5 | Kornit Storm HEXA | 1 | Freezing - Software/Axis Error | 2020-05-07 00:00:00 | 06:31:42 | 2020-05-07 00:00:00 | 06:32:09 | 2020-05-07 00:00:00 | 06:39:54 |  |  | [NAME] | [NAME]
708 | ATLAS_01 | [NAME] | 8 | Stain/Rust | 2020-05-07 00:00:00 | 07:15:32 | 2020-05-07 00:00:00 | 07:15:36 | 2020-05-07 00:00:00 | 07:43:56 |  |  | [NAME] | [NAME]
120 | KORNIT 3 | Kornit Storm HEXA | 1 | Spray Coverage | 2020-05-07 00:00:00 | 07:23:07 | 2020-05-07 00:00:00 | 07:28:15 | 2020-05-07 00:00:00 | 07:36:53 |  |  | [NAME] | [NAME]
582 | [NAME] | [NAME] (Neutra Fix++) | 3 | Banding - Cleaning/Purge & Wipe | 2020-05-07 00:00:00 | 07:41:43 | 2020-05-07 00:00:00 | 07:50:50 | 2020-05-07 00:00:00 | 07:50:55 |  |  | [NAME] | [NAME]
364 | K22_HEXA | Kornit Storm HEXA | 3 | Freezing - Software/Axis Error | 2020-05-07 00:00:00 | 07:50:35 | 2020-05-07 00:00:00 | 08:18:36 | 2020-05-07 00:00:00 | 08:18:39 |  |  | [NAME] | [NAME]
583 | K04_ATLAS | [NAME] (Neutra Fix++) | 3 | Banding - Cleaning/Purge & Wipe | 2020-05-07 00:00:00 | 08:04:27 | 2020-05-07 00:00:00 | 08:04:29 | 2020-05-07 00:00:00 | 08:07:00 |  |  | [NAME] | [NAME]
588 | ATLAS_01 | [NAME] | 4 | Regular Maintenance | 2020-05-07 00:00:00 | 08:26:54 | 2020-05-07 00:00:00 | 08:26:57 | 2020-05-07 00:00:00 | 10:26:43 |  |  | Juris Senkans | Juris Senkans
646 | [NAME] | [NAME] (Neutra Fix++) | 3 | Freezing - Software/Axis Error | 2020-05-07 00:00:00 | 09:15:48 | 2020-05-07 00:00:00 | 09:30:47 | 2020-05-07 00:00:00 | 09:49:30 |  |  | Schinitta Hopkins | [NAME]
145 | KORNIT 1 | Kornit Storm HEXA | 1 | Unknown | 2020-05-07 00:00:00 | 10:00:44 | 2020-05-07 00:00:00 | 10:08:33 | 2020-05-07 00:00:00 | 10:09:12 |  |  | [NAME] | [NAME]
198 | K12_HEXA | Kornit Storm HEXA | 3 | Other | 2020-05-07 00:00:00 | 13:01:23 | 2020-05-07 00:00:00 | 13:18:07 | 2020-05-07 00:00:00 | 13:18:14 |  |  | [NAME] | [NAME]
341 | KORNIT 01-4 | Kornit Storm HEXA | 4 | Regular Maintenance | 2020-05-07 00:00:00 | 13:11:58 | 2020-05-07 00:00:00 | 13:12:01 | 2020-05-07 00:00:00 | 13:20:02 |  |  | [NAME] | [NAME]
265 | KORNIT 01-3 | Kornit Storm HEXA | 4 | Regular Maintenance | 2020-05-07 00:00:00 | 13:12:08 | 2020-05-07 00:00:00 | 13:12:11 | 2020-05-07 00:00:00 | 13:20:10 |  |  | [NAME] | [NAME]
146 | KORNIT 4 | Kornit Storm HEXA | 1 | Regular Maintenance | 2020-05-07 00:00:00 | 13:51:17 | 2020-05-07 00:00:00 | 14:21:24 | 2020-05-07 00:00:00 | 14:30:29 |  |  | [NAME] | [NAME]
372 | K25_HEXA | Kornit Storm HEXA | 3 | Regular Maintenance | 2020-06-07 00:00:00 | 22:21:24 | 2020-06-08 00:00:00 | 00:00:21 | 2020-06-08 00:00:00 | 00:00:24 |  |  | [NAME] | [NAME]
582 | [NAME] | [NAME] (Neutra Fix++) | 3 | Regular Maintenance | 2020-06-08 00:00:00 | 00:48:46 | 2020-06-08 00:00:00 | 02:00:06 | 2020-06-08 00:00:00 | 02:00:09 |  |  | [NAME] | [NAME]
582 | [NAME] | [NAME] (Neutra Fix++) | 3 | Banding - Cleaning/Purge & Wipe | 2020-06-08 00:00:00 | 02:00:18 | 2020-06-08 00:00:00 | 02:42:36 | 2020-06-08 00:00:00 | 02:42:40 |  |  | [NAME] | [NAME]
788 | K05_ATLAS | [NAME] (Neutra Fix++) | 3 | Spray Coverage | 2020-06-08 00:00:00 | 03:05:38 | 2020-06-08 00:00:00 | 03:10:03 | 2020-06-08 00:00:00 | 03:10:06 |  |  | [NAME] | [NAME]
788 | K05_ATLAS | [NAME] (Neutra Fix++) | 3 | Freezing - Software/Axis Error | 2020-06-08 00:00:00 | 03:11:28 | 2020-06-08 00:00:00 | 03:25:22 | 2020-06-08 00:00:00 | 03:25:38 |  |  | [NAME] | [NAME]
363 | K21_HEXA | Kornit Storm HEXA | 3 | Other | 2020-06-08 00:00:00 | 03:13:29 | 2020-06-08 00:00:00 | 03:50:17 | 2020-06-08 00:00:00 | 03:53:26 |  |  | Amelia Valdez | [NAME]
439 | [NAME] | [NAME] ([NAME]) | 3 | Other | 2020-06-08 00:00:00 | 03:23:49 | 2020-06-08 00:00:00 | 04:14:08 | 2020-06-08 00:00:00 | 04:19:17 |  |  | [NAME] | [NAME]
788 | K05_ATLAS | [NAME] (Neutra Fix++) | 3 | Freezing - Software/Axis Error | 2020-06-08 00:00:00 | 03:28:25 | 2020-06-08 00:00:00 | 04:27:44 | 2020-06-08 00:00:00 | 04:27:47 |  |  | [NAME] | [NAME]
789 | [NAME] | [NAME] (Neutra Fix++) | 3 | Freezing - Software/Axis Error | 2020-06-08 00:00:00 | 03:31:56 | 2020-06-08 00:00:00 | 04:17:27 | 2020-06-08 00:00:00 | 04:17:29 |  |  | [NAME] | [NAME]
363 | K21_HEXA | Kornit Storm HEXA | 3 | Regular Maintenance | 2020-06-08 00:00:00 | 04:04:16 | 2020-06-08 00:00:00 | 04:09:18 | 2020-06-08 00:00:00 | 04:09:21 |  |  | [NAME] | [NAME]
788 | K05_ATLAS | [NAME] (Neutra Fix++) | 3 | Freezing - Software/Axis Error | 2020-06-08 00:00:00 | 04:43:42 | 2020-06-08 00:00:00 | 12:36:55 | 2020-06-08 00:00:00 | 12:36:57 |  |  | [NAME] | [NAME]
789 | [NAME] | [NAME] (Neutra Fix++) | 3 | Spray Coverage | 2020-06-08 00:00:00 | 05:13:36 | 2020-06-08 00:00:00 | 05:19:25 | 2020-06-08 00:00:00 | 05:19:27 |  |  | [NAME] | [NAME]