Spreadsheet: 165733d1341329695-countif-multiple-criteria-subtotal-not-working-well-together-example-forum
Sheet: Sheet1

Route | Code | Date
0015 | 12 | 2012-05-26 00:00:00
0030 | 02 | 2012-05-26 00:00:00
0070 | 03 | 2012-05-26 00:00:00
0090 | 12 | 2012-05-26 00:00:00
0130 | 03 | 2012-05-26 00:00:00
0140 | 16 | 2012-05-26 00:00:00
0010 | 02 | 2012-05-30 00:00:00
0030 | 16 | 2012-05-30 00:00:00
0050 | 02 | 2012-05-30 00:00:00
0060 | 12 | 2012-05-30 00:00:00
0060 | 02 | 2012-05-30 00:00:00
0070 | 03 | 2012-05-30 00:00:00
0100 | 12 | 2012-05-30 00:00:00
0120 | 02 | 2012-05-30 00:00:00
0130 | 16 | 2012-05-30 00:00:00
0130 | 27 | 2012-05-30 00:00:00
0040 | 16 | 2012-05-31 00:00:00
0040 | 12 | 2012-05-31 00:00:00
0060 | 02 | 2012-05-31 00:00:00
0090 | 04 | 2012-05-31 00:00:00
0090 | 04 | 2012-05-31 00:00:00
0090 | 04 | 2012-05-31 00:00:00
0090 | 04 | 2012-05-31 00:00:00
0110 | 02 | 2012-05-31 00:00:00
0010 | 04 | 2012-06-01 00:00:00
0080 | 03 | 2012-06-01 00:00:00
0090 | 02 | 2012-06-01 00:00:00
0010 | 02 | 2012-06-02 00:00:00
0030 | 02 | 2012-06-02 00:00:00
0040 | 02 | 2012-06-02 00:00:00
0040 | 02 | 2012-06-02 00:00:00
0050 | 03 | 2012-06-02 00:00:00
0130 | 27 | 2012-06-02 00:00:00
0150 | 27 | 2012-06-02 00:00:00
0015 | 16 | 2012-06-05 00:00:00
0020 | 02 | 2012-06-05 00:00:00
0050 | 03 | 2012-06-05 00:00:00
0070 | 03 | 2012-06-05 00:00:00
0070 | 03 | 2012-06-05 00:00:00
0080 | 04 | 2012-06-05 00:00:00
0090 | 04 | 2012-06-05 00:00:00
0120 | 27 | 2012-06-05 00:00:00
0010 | 04 | 2012-06-06 00:00:00
0110 | 02 | 2012-06-06 00:00:00
0130 | 02 | 2012-06-06 00:00:00
0130 | 03 | 2012-06-06 00:00:00
0140 | 16 | 2012-06-06 00:00:00
0010 | 02 | 2012-06-07 00:00:00
0010 | 17 | 2012-06-07 00:00:00
0015 | 04 | 2012-06-07 00:00:00
0015 | 04 | 2012-06-07 00:00:00
0015 | 12 | 2012-06-07 00:00:00
0030 | 02 | 2012-06-07 00:00:00
0040 | 03 | 2012-06-07 00:00:00
0120 | 02 | 2012-06-07 00:00:00
0010 | 02 | 2012-06-08 00:00:00
0020 | 17 | 2012-06-08 00:00:00
0050 | 02 | 2012-06-08 00:00:00
0050 | 02 | 2012-06-08 00:00:00
0060 | 04 | 2012-06-08 00:00:00
0090 | 04 | 2012-06-08 00:00:00
0130 | 85 | 2012-06-08 00:00:00
0130 | 27 | 2012-06-08 00:00:00
0030 | 02 | 2012-06-09 00:00:00
0030 | 16 | 2012-06-09 00:00:00
0050 | 16 | 2012-06-09 00:00:00
0060 | 01 | 2012-06-09 00:00:00
0060 | 16 | 2012-06-09 00:00:00
0070 | 16 | 2012-06-09 00:00:00
0090 | 17 | 2012-06-09 00:00:00
0015 | 04 | 2012-06-12 00:00:00
0015 | 12 | 2012-06-12 00:00:00
0040 | 02 | 2012-06-12 00:00:00
0070 | 04 | 2012-06-12 00:00:00
0090 | 02 | 2012-06-12 00:00:00
0100 | 16 | 2012-06-12 00:00:00
0120 | 04 | 2012-06-12 00:00:00
0120 | 04 | 2012-06-12 00:00:00
0140 | 02 | 2012-06-12 00:00:00
0140 | 02 | 2012-06-12 00:00:00
0140 | 04 | 2012-06-12 00:00:00
0140 | 04 | 2012-06-12 00:00:00
0140 | 04 | 2012-06-12 00:00:00
0140 | 12 | 2012-06-12 00:00:00
0015 | 02 | 2012-06-13 00:00:00
0030 | 16 | 2012-06-13 00:00:00
0040 | 12 | 2012-06-13 00:00:00
0070 | 03 | 2012-06-13 00:00:00
0090 | 02 | 2012-06-13 00:00:00
0120 | 04 | 2012-06-13 00:00:00
0120 | 04 | 2012-06-13 00:00:00
0140 | 02 | 2012-06-13 00:00:00
0140 | 02 | 2012-06-13 00:00:00
0040 | 04 | 2012-06-14 00:00:00
0080 | 04 | 2012-06-14 00:00:00
0110 | 02 | 2012-06-14 00:00:00
0010 | 17 | 2012-06-15 00:00:00
0020 | 04 | 2012-06-15 00:00:00
0040 | 04 | 2012-06-15 00:00:00
0080 | 01 | 2012-06-15 00:00:00
0080 | 01 | 2012-06-15 00:00:00
0090 | 02 | 2012-06-15 00:00:00
0090 | 02 | 2012-06-15 00:00:00
0090 | 04 | 2012-06-15 00:00:00
0040 | 02 | 2012-06-16 00:00:00
0040 | 16 | 2012-06-16 00:00:00
0050 | 02 | 2012-06-16 00:00:00
0015 | 04 | 2012-06-19 00:00:00
0015 | 04 | 2012-06-19 00:00:00
0015 | 04 | 2012-06-19 00:00:00
0015 | 04 | 2012-06-19 00:00:00
0015 | 04 | 2012-06-19 00:00:00
0015 | 04 | 2012-06-19 00:00:00
0015 | 04 | 2012-06-19 00:00:00
0015 | 04 | 2012-06-19 00:00:00
0015 | 04 | 2012-06-19 00:00:00
0040 | 04 | 2012-06-19 00:00:00
0040 | 04 | 2012-06-19 00:00:00
0090 | 02 | 2012-06-19 00:00:00
0090 | 02 | 2012-06-19 00:00:00
0120 | 02 | 2012-06-19 00:00:00
0015 | 10 | 2012-06-20 00:00:00
0030 | 02 | 2012-06-20 00:00:00
0040 | 02 | 2012-06-20 00:00:00
0040 | 02 | 2012-06-20 00:00:00
0040 | 02 | 2012-06-20 00:00:00
0040 | 02 | 2012-06-20 00:00:00
0040 | 02 | 2012-06-20 00:00:00
0050 | 12 | 2012-06-20 00:00:00
0080 | 02 | 2012-06-20 00:00:00
0090 | 04 | 2012-06-20 00:00:00
0120 | 02 | 2012-06-20 00:00:00
0120 | 16 | 2012-06-20 00:00:00
0010 | 04 | 2012-06-21 00:00:00
0010 | 04 | 2012-06-21 00:00:00
0010 | 04 | 2012-06-21 00:00:00
0010 | 04 | 2012-06-21 00:00:00
0010 | 04 | 2012-06-21 00:00:00
0080 | 02 | 2012-06-21 00:00:00
0080 | 27 | 2012-06-21 00:00:00
0090 | 12 | 2012-06-21 00:00:00
0120 | 02 | 2012-06-21 00:00:00
0130 | 16 | 2012-06-21 00:00:00
0104 | 02 | 2012-06-22 00:00:00
0104 | 04 | 2012-06-22 00:00:00
0104 | 04 | 2012-06-22 00:00:00
0104 | 04 | 2012-06-22 00:00:00
0122 | 02 | 2012-06-22 00:00:00
0136 | 04 | 2012-06-22 00:00:00
0144 | 04 | 2012-06-22 00:00:00
0305 | 04 | 2012-06-23 00:00:00
0305 | 17 | 2012-06-23 00:00:00
0353 | 02 | 2012-06-23 00:00:00
0353 | 02 | 2012-06-23 00:00:00
0375 | 02 | 2012-06-23 00:00:00
0381 | 02 | 2012-06-23 00:00:00
0302 | 04 | 2012-06-26 00:00:00
0303 | 02 | 2012-06-26 00:00:00
0303 | 17 | 2012-06-26 00:00:00
0305 | 02 | 2012-06-26 00:00:00
0337 | 02 | 2012-06-26 00:00:00
0338 | 04 | 2012-06-26 00:00:00
0338 | 04 | 2012-06-26 00:00:00
0350 | 12 | 2012-06-26 00:00:00
0350 | 12 | 2012-06-26 00:00:00
0350 | 12 | 2012-06-26 00:00:00
0354 | 02 | 2012-06-26 00:00:00
0354 | 17 | 2012-06-26 00:00:00
0302 | 04 | 2012-06-27 00:00:00
0338 | 03 | 2012-06-27 00:00:00
0338 | 03 | 2012-06-27 00:00:00
0339 | 02 | 2012-06-27 00:00:00
0350 | 03 | 2012-06-27 00:00:00
0006 | 27 | 2012-06-28 00:00:00
0301 | 02 | 2012-06-28 00:00:00
0301 | 12 | 2012-06-28 00:00:00
0301 | 12 | 2012-06-28 00:00:00
0301 | 12 | 2012-06-28 00:00:00
0301 | 12 | 2012-06-28 00:00:00
0302 | 04 | 2012-06-28 00:00:00
0302 | 04 | 2012-06-28 00:00:00
0302 | 04 | 2012-06-28 00:00:00
0303 | 04 | 2012-06-28 00:00:00
0306 | 02 | 2012-06-28 00:00:00
0306 | 02 | 2012-06-28 00:00:00
0338 | 03 | 2012-06-28 00:00:00
0305 | 11 | 2012-06-29 00:00:00
0338 | 03 | 2012-06-29 00:00:00
0338 | 03 | 2012-06-29 00:00:00
0338 | 12 | 2012-06-29 00:00:00
0350 | 02 | 2012-06-29 00:00:00
350 | 85 | 2012-06-29 00:00:00
0337 | 16 | 2012-06-30 00:00:00