Spreadsheet: 165758d1341333934-countif-multiple-criteria-subtotal-not-working-well-together-example-forum-oeldere-
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 |  | Aantal van Code
0030 | 16 | 2012-05-30 00:00:00 |  | Route | Date | Totaal
0050 | 02 | 2012-05-30 00:00:00 |  | 350 | 2012-06-29 00:00:00 | 1
0060 | 12 | 2012-05-30 00:00:00 |  | Totaal 350 |  | 1
0060 | 02 | 2012-05-30 00:00:00 |  | 0006 | 2012-06-28 00:00:00 | 1
0070 | 03 | 2012-05-30 00:00:00 |  | Totaal 0006 |  | 1
0100 | 12 | 2012-05-30 00:00:00 |  | 0010 | 2012-05-30 00:00:00 | 1
0120 | 02 | 2012-05-30 00:00:00 |  |  | 2012-06-01 00:00:00 | 1
0130 | 16 | 2012-05-30 00:00:00 |  |  | 2012-06-02 00:00:00 | 1
0130 | 27 | 2012-05-30 00:00:00 |  |  | 2012-06-06 00:00:00 | 1
0040 | 16 | 2012-05-31 00:00:00 |  |  | 2012-06-07 00:00:00 | 2
0040 | 12 | 2012-05-31 00:00:00 |  |  | 2012-06-08 00:00:00 | 1
0060 | 02 | 2012-05-31 00:00:00 |  |  | 2012-06-15 00:00:00 | 1
0090 | 04 | 2012-05-31 00:00:00 |  |  | 2012-06-21 00:00:00 | 5
0090 | 04 | 2012-05-31 00:00:00 |  | Totaal 0010 |  | 13
0090 | 04 | 2012-05-31 00:00:00 |  | 0015 | 2012-05-26 00:00:00 | 1
0090 | 04 | 2012-05-31 00:00:00 |  |  | 2012-06-05 00:00:00 | 1
0110 | 02 | 2012-05-31 00:00:00 |  |  | 2012-06-07 00:00:00 | 3
0010 | 04 | 2012-06-01 00:00:00 |  |  | 2012-06-12 00:00:00 | 2
0080 | 03 | 2012-06-01 00:00:00 |  |  | 2012-06-13 00:00:00 | 1
0090 | 02 | 2012-06-01 00:00:00 |  |  | 2012-06-19 00:00:00 | 9
0010 | 02 | 2012-06-02 00:00:00 |  |  | 2012-06-20 00:00:00 | 1
0030 | 02 | 2012-06-02 00:00:00 |  | Totaal 0015 |  | 18
0040 | 02 | 2012-06-02 00:00:00 |  | 0020 | 2012-06-05 00:00:00 | 1
0040 | 02 | 2012-06-02 00:00:00 |  |  | 2012-06-08 00:00:00 | 1
0050 | 03 | 2012-06-02 00:00:00 |  |  | 2012-06-15 00:00:00 | 1
0130 | 27 | 2012-06-02 00:00:00 |  | Totaal 0020 |  | 3
0150 | 27 | 2012-06-02 00:00:00 |  | 0030 | 2012-05-26 00:00:00 | 1
0015 | 16 | 2012-06-05 00:00:00 |  |  | 2012-05-30 00:00:00 | 1
0020 | 02 | 2012-06-05 00:00:00 |  |  | 2012-06-02 00:00:00 | 1
0050 | 03 | 2012-06-05 00:00:00 |  |  | 2012-06-07 00:00:00 | 1
0070 | 03 | 2012-06-05 00:00:00 |  |  | 2012-06-09 00:00:00 | 2
0070 | 03 | 2012-06-05 00:00:00 |  |  | 2012-06-13 00:00:00 | 1
0080 | 04 | 2012-06-05 00:00:00 |  |  | 2012-06-20 00:00:00 | 1
0090 | 04 | 2012-06-05 00:00:00 |  | Totaal 0030 |  | 8
0120 | 27 | 2012-06-05 00:00:00 |  | 0040 | 2012-05-31 00:00:00 | 2
0010 | 04 | 2012-06-06 00:00:00 |  |  | 2012-06-02 00:00:00 | 2
0110 | 02 | 2012-06-06 00:00:00 |  |  | 2012-06-07 00:00:00 | 1
0130 | 02 | 2012-06-06 00:00:00 |  |  | 2012-06-12 00:00:00 | 1
0130 | 03 | 2012-06-06 00:00:00 |  |  | 2012-06-13 00:00:00 | 1
0140 | 16 | 2012-06-06 00:00:00 |  |  | 2012-06-14 00:00:00 | 1
0010 | 02 | 2012-06-07 00:00:00 |  |  | 2012-06-15 00:00:00 | 1
0010 | 17 | 2012-06-07 00:00:00 |  |  | 2012-06-16 00:00:00 | 2
0015 | 04 | 2012-06-07 00:00:00 |  |  | 2012-06-19 00:00:00 | 2
0015 | 04 | 2012-06-07 00:00:00 |  |  | 2012-06-20 00:00:00 | 5
0015 | 12 | 2012-06-07 00:00:00 |  | Totaal 0040 |  | 18
0030 | 02 | 2012-06-07 00:00:00 |  | 0050 | 2012-05-30 00:00:00 | 1
0040 | 03 | 2012-06-07 00:00:00 |  |  | 2012-06-02 00:00:00 | 1
0120 | 02 | 2012-06-07 00:00:00 |  |  | 2012-06-05 00:00:00 | 1
0010 | 02 | 2012-06-08 00:00:00 |  |  | 2012-06-08 00:00:00 | 2
0020 | 17 | 2012-06-08 00:00:00 |  |  | 2012-06-09 00:00:00 | 1
0050 | 02 | 2012-06-08 00:00:00 |  |  | 2012-06-16 00:00:00 | 1
0050 | 02 | 2012-06-08 00:00:00 |  |  | 2012-06-20 00:00:00 | 1
0060 | 04 | 2012-06-08 00:00:00 |  | Totaal 0050 |  | 8
0090 | 04 | 2012-06-08 00:00:00 |  | 0060 | 2012-05-30 00:00:00 | 2
0130 | 85 | 2012-06-08 00:00:00 |  |  | 2012-05-31 00:00:00 | 1
0130 | 27 | 2012-06-08 00:00:00 |  |  | 2012-06-08 00:00:00 | 1
0030 | 02 | 2012-06-09 00:00:00 |  |  | 2012-06-09 00:00:00 | 2
0030 | 16 | 2012-06-09 00:00:00 |  | Totaal 0060 |  | 6
0050 | 16 | 2012-06-09 00:00:00 |  | 0070 | 2012-05-26 00:00:00 | 1
0060 | 01 | 2012-06-09 00:00:00 |  |  | 2012-05-30 00:00:00 | 1
0060 | 16 | 2012-06-09 00:00:00 |  |  | 2012-06-05 00:00:00 | 2
0070 | 16 | 2012-06-09 00:00:00 |  |  | 2012-06-09 00:00:00 | 1
0090 | 17 | 2012-06-09 00:00:00 |  |  | 2012-06-12 00:00:00 | 1
0015 | 04 | 2012-06-12 00:00:00 |  |  | 2012-06-13 00:00:00 | 1
0015 | 12 | 2012-06-12 00:00:00 |  | Totaal 0070 |  | 7
0040 | 02 | 2012-06-12 00:00:00 |  | 0080 | 2012-06-01 00:00:00 | 1
0070 | 04 | 2012-06-12 00:00:00 |  |  | 2012-06-05 00:00:00 | 1
0090 | 02 | 2012-06-12 00:00:00 |  |  | 2012-06-14 00:00:00 | 1
0100 | 16 | 2012-06-12 00:00:00 |  |  | 2012-06-15 00:00:00 | 2
0120 | 04 | 2012-06-12 00:00:00 |  |  | 2012-06-20 00:00:00 | 1
0120 | 04 | 2012-06-12 00:00:00 |  |  | 2012-06-21 00:00:00 | 2
0140 | 02 | 2012-06-12 00:00:00 |  | Totaal 0080 |  | 8
0140 | 02 | 2012-06-12 00:00:00 |  | 0090 | 2012-05-26 00:00:00 | 1
0140 | 04 | 2012-06-12 00:00:00 |  |  | 2012-05-31 00:00:00 | 4
0140 | 04 | 2012-06-12 00:00:00 |  |  | 2012-06-01 00:00:00 | 1
0140 | 04 | 2012-06-12 00:00:00 |  |  | 2012-06-05 00:00:00 | 1
0140 | 12 | 2012-06-12 00:00:00 |  |  | 2012-06-08 00:00:00 | 1
0015 | 02 | 2012-06-13 00:00:00 |  |  | 2012-06-09 00:00:00 | 1
0030 | 16 | 2012-06-13 00:00:00 |  |  | 2012-06-12 00:00:00 | 1
0040 | 12 | 2012-06-13 00:00:00 |  |  | 2012-06-13 00:00:00 | 1
0070 | 03 | 2012-06-13 00:00:00 |  |  | 2012-06-15 00:00:00 | 3
0090 | 02 | 2012-06-13 00:00:00 |  |  | 2012-06-19 00:00:00 | 2
0120 | 04 | 2012-06-13 00:00:00 |  |  | 2012-06-20 00:00:00 | 1
0120 | 04 | 2012-06-13 00:00:00 |  |  | 2012-06-21 00:00:00 | 1
0140 | 02 | 2012-06-13 00:00:00 |  | Totaal 0090 |  | 18
0140 | 02 | 2012-06-13 00:00:00 |  | 0100 | 2012-05-30 00:00:00 | 1
0040 | 04 | 2012-06-14 00:00:00 |  |  | 2012-06-12 00:00:00 | 1
0080 | 04 | 2012-06-14 00:00:00 |  | Totaal 0100 |  | 2
0110 | 02 | 2012-06-14 00:00:00 |  | 0104 | 2012-06-22 00:00:00 | 4
0010 | 17 | 2012-06-15 00:00:00 |  | Totaal 0104 |  | 4
0020 | 04 | 2012-06-15 00:00:00 |  | 0110 | 2012-05-31 00:00:00 | 1
0040 | 04 | 2012-06-15 00:00:00 |  |  | 2012-06-06 00:00:00 | 1
0080 | 01 | 2012-06-15 00:00:00 |  |  | 2012-06-14 00:00:00 | 1
0080 | 01 | 2012-06-15 00:00:00 |  | Totaal 0110 |  | 3
0090 | 02 | 2012-06-15 00:00:00 |  | 0120 | 2012-05-30 00:00:00 | 1
0090 | 02 | 2012-06-15 00:00:00 |  |  | 2012-06-05 00:00:00 | 1
0090 | 04 | 2012-06-15 00:00:00 |  |  | 2012-06-07 00:00:00 | 1
0040 | 02 | 2012-06-16 00:00:00 |  |  | 2012-06-12 00:00:00 | 2
0040 | 16 | 2012-06-16 00:00:00 |  |  | 2012-06-13 00:00:00 | 2
0050 | 02 | 2012-06-16 00:00:00 |  |  | 2012-06-19 00:00:00 | 1
0015 | 04 | 2012-06-19 00:00:00 |  |  | 2012-06-20 00:00:00 | 2
0015 | 04 | 2012-06-19 00:00:00 |  |  | 2012-06-21 00:00:00 | 1
0015 | 04 | 2012-06-19 00:00:00 |  | Totaal 0120 |  | 11
0015 | 04 | 2012-06-19 00:00:00 |  | 0122 | 2012-06-22 00:00:00 | 1
0015 | 04 | 2012-06-19 00:00:00 |  | Totaal 0122 |  | 1
0015 | 04 | 2012-06-19 00:00:00 |  | 0130 | 2012-05-26 00:00:00 | 1
0015 | 04 | 2012-06-19 00:00:00 |  |  | 2012-05-30 00:00:00 | 2
0015 | 04 | 2012-06-19 00:00:00 |  |  | 2012-06-02 00:00:00 | 1
0015 | 04 | 2012-06-19 00:00:00 |  |  | 2012-06-06 00:00:00 | 2
0040 | 04 | 2012-06-19 00:00:00 |  |  | 2012-06-08 00:00:00 | 2
0040 | 04 | 2012-06-19 00:00:00 |  |  | 2012-06-21 00:00:00 | 1
0090 | 02 | 2012-06-19 00:00:00 |  | Totaal 0130 |  | 9
0090 | 02 | 2012-06-19 00:00:00 |  | 0136 | 2012-06-22 00:00:00 | 1
0120 | 02 | 2012-06-19 00:00:00 |  | Totaal 0136 |  | 1
0015 | 10 | 2012-06-20 00:00:00 |  | 0140 | 2012-05-26 00:00:00 | 1
0030 | 02 | 2012-06-20 00:00:00 |  |  | 2012-06-06 00:00:00 | 1
0040 | 02 | 2012-06-20 00:00:00 |  |  | 2012-06-12 00:00:00 | 6
0040 | 02 | 2012-06-20 00:00:00 |  |  | 2012-06-13 00:00:00 | 2
0040 | 02 | 2012-06-20 00:00:00 |  | Totaal 0140 |  | 10
0040 | 02 | 2012-06-20 00:00:00 |  | 0144 | 2012-06-22 00:00:00 | 1
0040 | 02 | 2012-06-20 00:00:00 |  | Totaal 0144 |  | 1
0050 | 12 | 2012-06-20 00:00:00 |  | 0150 | 2012-06-02 00:00:00 | 1
0080 | 02 | 2012-06-20 00:00:00 |  | Totaal 0150 |  | 1
0090 | 04 | 2012-06-20 00:00:00 |  | 0301 | 2012-06-28 00:00:00 | 5
0120 | 02 | 2012-06-20 00:00:00 |  | Totaal 0301 |  | 5
0120 | 16 | 2012-06-20 00:00:00 |  | 0302 | 2012-06-26 00:00:00 | 1
0010 | 04 | 2012-06-21 00:00:00 |  |  | 2012-06-27 00:00:00 | 1
0010 | 04 | 2012-06-21 00:00:00 |  |  | 2012-06-28 00:00:00 | 3
0010 | 04 | 2012-06-21 00:00:00 |  | Totaal 0302 |  | 5
0010 | 04 | 2012-06-21 00:00:00 |  | 0303 | 2012-06-26 00:00:00 | 2
0010 | 04 | 2012-06-21 00:00:00 |  |  | 2012-06-28 00:00:00 | 1
0080 | 02 | 2012-06-21 00:00:00 |  | Totaal 0303 |  | 3
0080 | 27 | 2012-06-21 00:00:00 |  | 0305 | 2012-06-23 00:00:00 | 2
0090 | 12 | 2012-06-21 00:00:00 |  |  | 2012-06-26 00:00:00 | 1
0120 | 02 | 2012-06-21 00:00:00 |  |  | 2012-06-29 00:00:00 | 1
0130 | 16 | 2012-06-21 00:00:00 |  | Totaal 0305 |  | 4
0104 | 02 | 2012-06-22 00:00:00 |  | 0306 | 2012-06-28 00:00:00 | 2
0104 | 04 | 2012-06-22 00:00:00 |  | Totaal 0306 |  | 2
0104 | 04 | 2012-06-22 00:00:00 |  | 0337 | 2012-06-26 00:00:00 | 1
0104 | 04 | 2012-06-22 00:00:00 |  |  | 2012-06-30 00:00:00 | 1
0122 | 02 | 2012-06-22 00:00:00 |  | Totaal 0337 |  | 2
0136 | 04 | 2012-06-22 00:00:00 |  | 0338 | 2012-06-26 00:00:00 | 2
0144 | 04 | 2012-06-22 00:00:00 |  |  | 2012-06-27 00:00:00 | 2
0305 | 04 | 2012-06-23 00:00:00 |  |  | 2012-06-28 00:00:00 | 1
0305 | 17 | 2012-06-23 00:00:00 |  |  | 2012-06-29 00:00:00 | 3
0353 | 02 | 2012-06-23 00:00:00 |  | Totaal 0338 |  | 8
0353 | 02 | 2012-06-23 00:00:00 |  | 0339 | 2012-06-27 00:00:00 | 1
0375 | 02 | 2012-06-23 00:00:00 |  | Totaal 0339 |  | 1
0381 | 02 | 2012-06-23 00:00:00 |  | 0350 | 2012-06-26 00:00:00 | 3
0302 | 04 | 2012-06-26 00:00:00 |  |  | 2012-06-27 00:00:00 | 1
0303 | 02 | 2012-06-26 00:00:00 |  |  | 2012-06-29 00:00:00 | 1
0303 | 17 | 2012-06-26 00:00:00 |  | Totaal 0350 |  | 5
0305 | 02 | 2012-06-26 00:00:00 |  | 0353 | 2012-06-23 00:00:00 | 2
0337 | 02 | 2012-06-26 00:00:00 |  | Totaal 0353 |  | 2
0338 | 04 | 2012-06-26 00:00:00 |  | 0354 | 2012-06-26 00:00:00 | 2
0338 | 04 | 2012-06-26 00:00:00 |  | Totaal 0354 |  | 2
0350 | 12 | 2012-06-26 00:00:00 |  | 0375 | 2012-06-23 00:00:00 | 1
0350 | 12 | 2012-06-26 00:00:00 |  | Totaal 0375 |  | 1
0350 | 12 | 2012-06-26 00:00:00 |  | 0381 | 2012-06-23 00:00:00 | 1
0354 | 02 | 2012-06-26 00:00:00 |  | Totaal 0381 |  | 1
0354 | 17 | 2012-06-26 00:00:00 |  | Eindtotaal |  | 193
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