Spreadsheet: 329476d1404317853-adding-indirect-formula-to-a-countif-es3-cs-wholesale-load-tracking-report-test
Sheet: 05-01

REPORTING UPDATE TIME | TRUCK # | ROUTE # | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00 | L111 | 45201 | Hammond | 03:08:00 | 04:14:00 |  | 434 | 200 |  |  |  |  | 525
08:00:00 |  |  |  |  |  |  |  | 140
09:00:00 |  |  |  |  |  |  |  | 100
10:00:00 |  |  |  |  |  |  |  | 25
11:00:00 |  |  |  |  |  |  |  |  |  | 11:02:00 | 12:19:00 |  |  | 10
12:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:49:00 | 13:30:00
13:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00 | 32804 | 45202 | Hammond | 03:45:00 | 04:20:00 |  | [NAME] | 168
08:00:00 |  |  |  |  |  |  | [NAME] | 120
09:00:00 |  |  |  |  |  |  | [NAME] | 39
10:00:00 |  |  |  |  |  |  | [NAME] |  |  | 09:56:00 | 10:10:00
11:00:00 |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00 | 21525 | 45203 | Hammond | 03:08:00 | 04:14:00 |  | [NAME] | 171
08:00:00 |  |  |  |  |  |  | [NAME] | 117
09:00:00 |  |  |  |  |  |  | [NAME] | 40
10:00:00 |  |  |  |  |  |  | [NAME] |  |  | 10:00:00 | 10:10:00
11:00:00 |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00 | 34084 | 45204 | Hammond | 03:45:00 | 04:15:00 |  | [NAME] | 146
08:00:00 |  |  |  |  |  |  | [NAME] | 86
09:00:00 |  |  |  |  |  |  | [NAME] | 30
10:00:00 |  |  |  |  |  |  | [NAME] |  |  | 09:45:00 | 10:00:00
11:00:00 |  |  |  |  |  |  | [NAME]
12:00:00 |  |  |  |  |  |  | [NAME]
13:00:00 |  |  |  |  |  |  | [NAME]
REPORTING UPDATE TIME | TRUCK # | ROUTE # | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | 422 | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00 | 21580 | 45205 | Hammond | 03:00:00 | 04:16:00 |  | [NAME] | 177
08:00:00 |  |  |  |  |  |  | [NAME] | 90
09:00:00 |  |  |  |  |  |  | [NAME] | 40
10:00:00 |  |  |  |  |  |  | [NAME] |  |  | 09:48:00 | 10:15:00
11:00:00 |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00 | 672167 | 45206 | Hammond | 03:30:00 | 04:30:00 |  | [NAME] | 128
08:00:00 |  |  |  |  |  |  | [NAME] | 88
09:00:00 |  |  |  |  |  |  | [NAME] | 30
10:00:00 |  |  |  |  |  |  | [NAME] |  | 10:20:00 | 10:25:00
11:00:00 |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00