Spreadsheet: 137368d1327079059-cannot-get-a-formula-array-to-return-the-correct-count-of-list-items-example-extract
Sheet: Sheet1

 |  | INPUT ROUTE 1 (3-1-3) |  |  |  | TYPE | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | 10th | 11th | 12th | 13th | 14th | 15th | 16th |  | SET TIME BREAKS
START | ANY START | START 1 | START 2 | START 3 |  | R3 | 1B | 2A | 2B | 3A | 1B | 1B | 2A | 1A | 3B | 4B |  |  |  |  |  |  |  | 08:00:00 | 0.3333333333333333
 |  | 1A | NONE | NONE |  |  | 08:46:00 | 08:49:00 | 11:27:00 | 11:31:00 | 11:32:00 | 11:32:00 | 11:55:00 | 13:24:00 | 15:03:00 | 16:06:00 |  |  |  |  |  |  |  | 09:00:00 | 0.375
Through POINTS | ANY CONN | CONN 1 |  |  |  | A4 | 1A | 1A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:00:00 | 0.4166666666666667
 |  | 2A |  |  |  |  | 07:29:00 | 11:47:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:00:00 | 0.4583333333333333
END | ANY END | END 1 | END 2 | END 3 |  | R2 | 2A | 4B | 4A | 2B |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:00:00 | 0.5
 |  | 3B | 4B | NONE |  |  | 08:58:00 | 09:02:00 | 16:09:00 | 16:14:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:00:00 | 0.5416666666666666
 |  |  |  |  |  | R2 | 1A | 2A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:00:00 | 0.5833333333333334
 |  |  |  |  |  |  | 08:21:00 | 08:23:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:00:00 | 0.625
 | ANY START | ANY END |  |  |  | R4 | 1A | 2A | 3B |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:00:00 | 0.6666666666666666
START | ANY START | START 1 | START 2 | START 3 |  |  | 12:09:00 | 12:10:00 | 12:15:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:00:00 | 0.7083333333333334
 |  | 1A | NONE | NONE |  | A6 | 4A | 2B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:00:00 | 0.75
Through POINTS | ANY CONN | CONN 1 | 2A |  |  |  | 14:19:00 | 14:25:00
END | ANY END | END 1 | END 2 | END 3 |  | R4 | 1B | 1A
 |  | 3B | 4B | NONE |  |  | 10:43:00 | 13:26:00
 |  | RESULT | 1A,NONE,NONE   VIA ,2A TO 3B,4B,NONE | Missed 2A |  | A5 | 1A | 2A | 4B
 |  | 08:00 - 09:00 | 4 | 1 |  |  | 13:44:00 | 13:45:00 | 13:50:00
 |  | 09:00 - 10:00 | 1 | 0 |  | R2 | 3A | 2A
 |  | 10:00 -11:00 | 0 | 1 |  |  | 13:57:00 | 14:01:00
 |  | 11:00 - 1200 | 1 | 2 |  | A5 | 4A | 2B
 |  | 12:00 - 13:00 | 2 | 1 |  |  | 14:07:00 | 15:24:00
 |  | 13:00 - 14:00 | 2 | 4 |  | R2 | 4B | 4A
 |  | 14:00 - 15:00 | 1 | 1 |  |  | 11:51:00 | 12:50:00
 |  | 15:00 - 16:00 | 0 | 1 |  | A6 | 4A | 2A
 |  | 16:00 - 17:00 | 0 | 0 |  |  | 11:02:00 | 11:07:00
 |  | 17:00 - 18:00 | 0 | 0 |  | A5 | 4A | 2A | 4A | 2A
 |  | TOTALS | 11 | 11 |  |  | 11:02:00 | 11:07:00 | 14:05:00 | 14:09:00
 |  |  |  |  |  | A6 | 4A | 2B | 2A
 |  | INPUT ROUTE 1 (3-1-3) |  |  |  |  | 11:44:00 | 11:49:00 | 13:25:00
 |  | 1A,NONE,NONE   VIA ,2A TO 3B,4B,NONE |  |  |  | R3 | 1A | 4A | 1B
 | ALL | R4 |  |  |  |  | 07:04:00 | 09:34:00 | 09:40:00
08:00 - 09:00 | 4 | 3 |  |  |  | R3 | 2A | 4B
09:00 - 10:00 | 1 | 0 |  |  |  |  | 07:05:00 | 07:09:00
10:00 -11:00 | 0 | 0 |  |  |  | R3 | 3B | 4A | 2B
11:00 - 1200 | 1 | 0 |  |  |  |  | 07:54:00 | 14:42:00 | 14:47:00
12:00 - 13:00 | 2 | 1 |  |  |  | R2 | 3A | 4B
13:00 - 14:00 | 2 | 0 |  |  |  |  | 09:41:00 | 14:00:00
14:00 - 15:00 | 1 | 0 |  |  |  | R2 | 1A | 2A | 4B | 4A | 2B
15:00 - 16:00 | 0 | 0 |  |  |  |  | 08:51:00 | 08:53:00 | 08:56:00 | 09:35:00 | 09:40:00
16:00 - 17:00 | 0 | 0 |  |  |  | R2 | 1A | 4B
17:00 - 18:00 | 0 | 0 |  |  |  |  | 12:18:00 | 12:37:00
 | 11 | 4 |  |  |  | A4 | 3B | 3A
 |  |  |  |  |  |  | 08:06:00 | 15:14:00
 |  |  |  |  |  | A6 | 4A | 1B | 2B
 |  |  |  |  |  |  | 11:44:00 | 11:49:00 | 11:49:00
 |  |  |  |  |  | R3 | 3B | 1A
 |  |  |  |  |  |  | 07:23:00 | 12:09:00
 |  |  |  |  |  | R3 | 4A | 1B
 |  |  |  |  |  |  | 11:23:00 | 11:28:00
 |  |  |  |  |  | R3 | 4A | 1B | 1A | 2A | 4B
 |  |  |  |  |  |  | 12:23:00 | 12:30:00 | 12:50:00 | 12:50:00 | 12:55:00
 |  |  |  |  |  | R2 | 4A | 2B | 1B
 |  |  |  |  |  |  | 13:45:00 | 13:49:00 | 13:51:00
 |  |  |  |  |  | R3 | 1A | 1B | 1A | 1B
 |  |  |  |  |  |  | 13:49:00 | 14:05:00 | 14:08:00 | 14:21:00
 |  |  |  |  |  | R4 | 1A | 1A
 |  |  |  |  |  |  | 07:31:00 | 13:25:00
 |  |  |  |  |  | R2 | 1A | 4B
 |  |  |  |  |  |  | 10:49:00 | 10:55:00
 |  |  |  |  |  | A6 | 4A | 2B
 |  |  |  |  |  |  | 14:07:00 | 15:24:00
 |  |  |  |  |  | A6 | 2A | 4B | 4A | 2B | 1B
 |  |  |  |  |  |  | 13:56:00 | 14:02:00 | 14:58:00 | 15:03:00 | 15:05:00
 |  |  |  |  |  | R2 | 3B | 3A
 |  |  |  |  |  |  | 07:44:00 | 08:12:00
 |  |  |  |  |  | R2 | 1A | 4B
 |  |  |  |  |  |  | 14:08:00 | 14:13:00
 |  |  |  |  |  | R4 | 4A | 1B | 2B
 |  |  |  |  |  |  | 11:53:00 | 11:58:00 | 11:58:00
 |  |  |  |  |  | R2 | 1A | 4B | 4A | 2B
 |  |  |  |  |  |  | 13:31:00 | 13:39:00 | 14:41:00 | 14:46:00
 |  |  |  |  |  | R4 | 4A | 2B | 1B
 |  |  |  |  |  |  | 13:59:00 | 14:04:00 | 14:05:00
 |  |  |  |  |  | R2 | 1A | 2A
 |  |  |  |  |  |  | 08:21:00 | 08:23:00
 |  |  |  |  |  | A4 | 4A | 2B
 |  |  |  |  |  |  | 15:44:00 | 15:49:00
 |  |  |  |  |  | A5 | 1B | 2B | 1A | 2A | 4B
 |  |  |  |  |  |  | 07:02:00 | 07:02:00 | 09:31:00 | 10:30:00 | 10:34:00
 |  |  |  |  |  | R2 | 1B | 1A
 |  |  |  |  |  |  | 13:08:00 | 13:10:00
 |  |  |  |  |  | R4 | 1A | 2B | 3B | 3A | 3B
 |  |  |  |  |  |  | 12:05:00 | 13:40:00 | 13:45:00 | 14:31:00 | 15:38:00
 |  |  |  |  |  | A5 | 1B | 1A
 |  |  |  |  |  |  | 13:36:00 | 13:39:00
 |  |  |  |  |  | R2 | 4A | 2B | 1B | 1A | 4B
 |  |  |  |  |  |  | 08:21:00 | 08:28:00 | 08:32:00 | 11:55:00 | 12:02:00
 |  |  |  |  |  | R2 | 1B | 1B
 |  |  |  |  |  |  | 07:10:00 | 09:28:00
 |  |  |  |  |  | R2 | 1A | 2A | 2B
 |  |  |  |  |  |  | 13:59:00 | 14:00:00 | 14:23:00
 |  |  |  |  |  | R2 | 1A | 3B
 |  |  |  |  |  |  | 11:00:00 | 11:07:00
 |  |  |  |  |  | A5 | 3B | 3A | 2B | 1B
 |  |  |  |  |  |  | 11:46:00 | 14:18:00 | 14:24:00 | 14:28:00
 |  |  |  |  |  | R4 | 4A | 1A | 2A | 4B
 |  |  |  |  |  |  | 07:58:00 | 13:03:00 | 13:04:00 | 13:09:00
 |  |  |  |  |  | A4 | 1A | 1B
 |  |  |  |  |  |  | 07:02:00 | 08:28:00
 |  |  |  |  |  | R4 | 4A | 2B
 |  |  |  |  |  |  | 14:16:00 | 14:20:00
 |  |  |  |  |  | R4 | 1A | 2A | 3B | 1A | 2A | 3B
 |  |  |  |  |  |  | 07:58:00 | 08:00:00 | 08:06:00 | 14:39:00 | 14:40:00 | 14:44:00
 |  |  |  |  |  | R4 | 1A | 2A | 3B
 |  |  |  |  |  |  | 08:05:00 | 08:07:00 | 08:11:00
 |  |  |  |  |  | R4 | 1A | 4B
 |  |  |  |  |  |  | 08:48:00 | 08:53:00
 |  |  |  |  |  | R4 | 1A | 2A | 3B
 |  |  |  |  |  |  | 08:08:00 | 08:10:00 | 08:13:00
 |  |  |  |  |  | A6 | 4A | 2B | 1B
 |  |  |  |  |  |  | 08:39:00 | 08:45:00 | 08:49:00
 |  |  |  |  |  | A5 | 4A | 2A
 |  |  |  |  |  |  | 12:24:00 | 12:29:00
 |  |  |  |  |  | A5 | 3A | 1B | 2B
 |  |  |  |  |  |  | 09:55:00 | 10:01:00 | 10:01:00
 |  |  |  |  |  | A5 | 4A | 2B
 |  |  |  |  |  |  | 10:22:00 | 10:27:00
 |  |  |  |  |  | R3 | 1A | 2B | 4B
 |  |  |  |  |  |  | 11:14:00 | 11:34:00 | 11:38:00
 |  |  |  |  |  | A5 | 4A | 2B | 1B
 |  |  |  |  |  |  | 11:01:00 | 11:05:00 | 11:07:00
 |  |  |  |  |  | A5 | 1A | 1B
 |  |  |  |  |  |  | 10:51:00 | 13:53:00
 |  |  |  |  |  | A4 | 4A | 2B | 1B
 |  |  |  |  |  |  | 15:49:00 | 15:56:00 | 15:58:00
 |  |  |  |  |  | R2 | 1A | 2A | 2B
 |  |  |  |  |  |  | 08:54:00 | 08:55:00 | 09:17:00
 |  |  |  |  |  | R2 | 2B | 3A
 |  |  |  |  |  |  | 13:20:00 | 13:53:00
 |  |  |  |  |  | A6 | 3A | 2B | 1B
 |  |  |  |  |  |  | 09:52:00 | 09:58:00 | 10:00:00
 |  |  |  |  |  | A6 | 2A | 1A | 4B
 |  |  |  |  |  |  | 15:39:00 | 15:41:00 | 15:48:00
 |  |  |  |  |  | A6 | 4A | 2B | 1B
 |  |  |  |  |  |  | 15:13:00 | 15:19:00 | 15:24:00
 |  |  |  |  |  | R2 | 1B | 1A
 |  |  |  |  |  |  | 08:16:00 | 15:37:00
 |  |  |  |  |  | R3 | 1A | 1B | 1A
 |  |  |  |  |  |  | 11:02:00 | 11:57:00 | 15:28:00
 |  |  |  |  |  | R3 | 1A | 2A | 4B
 |  |  |  |  |  |  | 11:06:00 | 11:07:00 | 11:12:00
 |  |  |  |  |  | A6 | 3A | 2B | 1B
 |  |  |  |  |  |  | 09:29:00 | 09:37:00 | 09:40:00
 |  |  |  |  |  | R2 | 1A | 1A
 |  |  |  |  |  |  | 11:38:00 | 13:26:00
 |  |  |  |  |  | R2 | 1A | 4B
 |  |  |  |  |  |  | 13:37:00 | 13:41:00
 |  |  |  |  |  | R2 | 1A | 2A
 |  |  |  |  |  |  | 12:39:00 | 12:40:00
 |  |  |  |  |  | R3 | 1A | 1B
 |  |  |  |  |  |  | 14:33:00 | 14:44:00
 |  |  |  |  |  | R4 | 1A | 2A | 4B | 4A | 2B | 1A | 4B
 |  |  |  |  |  |  | 08:02:00 | 08:02:00 | 08:06:00 | 08:52:00 | 08:56:00 | 13:35:00 | 13:40:00
 |  |  |  |  |  | A4 | 4A | 2B
 |  |  |  |  |  |  | 15:40:00 | 15:45:00
 |  |  |  |  |  | R4 | 4A | 2A
 |  |  |  |  |  |  | 13:33:00 | 13:37:00
 |  |  |  |  |  | A5 | 4A | 2B
 |  |  |  |  |  |  | 11:00:00 | 11:02:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0