Spreadsheet: 91958d1291653229-formula-to-return-multiple-answers-matching-criteria-truckpvt2
Sheet: Data

 | #N/A |  | 7 | 4 | 5 | 4 | 5
 | Date |  | 115 | 116 | 117 | 118 | 121 |  |  | Date | Truck | Days
 |  |  |  |  |  |  |  |  |  | 2009-12-01 00:00:00 | 115 |  |  | Count of Days | Column Labels
 | 2009-12-01 00:00:00 |  |  |  |  | 1 |  |  |  | 2009-12-01 00:00:00 | 115 |  |  | Row Labels | 115 | 116 | 117 | 118 | 121 | Grand Total
 | 2009-12-01 00:00:00 |  |  |  |  |  |  |  |  | 2009-12-01 00:00:00 | 115 |  |  | 2009-12-01 00:00:00 |  |  |  | 1 |  | 1
 | 2009-12-01 00:00:00 |  |  |  |  |  |  |  |  | 2009-12-02 00:00:00 | 115 |  |  | 2009-12-02 00:00:00 |  |  | 1 | 1 |  | 2
 | 2009-12-02 00:00:00 |  |  |  |  | 1 |  |  |  | 2009-12-02 00:00:00 | 115 |  |  | 2009-12-03 00:00:00 | 2 | 1 | 1 | 1 |  | 5
 | 2009-12-02 00:00:00 |  |  |  |  |  |  |  |  | 2009-12-02 00:00:00 | 115 |  |  | 2009-12-04 00:00:00 |  | 1 | 1 | 1 |  | 3
 | 2009-12-02 00:00:00 |  |  |  | 0.5 |  |  |  |  | 2009-12-03 00:00:00 | 115 |  |  | 2009-12-06 00:00:00
 | 2009-12-03 00:00:00 |  |  | 1 | 0.5 |  |  |  |  | 2009-12-03 00:00:00 | 115 | 0.5 |  | 2009-12-07 00:00:00 | 1 | 1 |  |  | 1 | 3
 | 2009-12-03 00:00:00 |  | 0.5 |  |  |  |  |  |  | 2009-12-03 00:00:00 | 115 | 0.5 |  | 2009-12-08 00:00:00 | 2 | 1 |  |  | 1 | 4
 | 2009-12-03 00:00:00 |  | 0.5 |  |  | 1 |  |  |  | 2009-12-04 00:00:00 | 115 |  |  | 2009-12-09 00:00:00 | 1 |  | 1 |  | 1 | 3
 | 2009-12-04 00:00:00 |  |  |  |  | 1 |  |  |  | 2009-12-04 00:00:00 | 115 |  |  | 2009-12-10 00:00:00 | 1 |  | 1 |  | 2 | 4
 | 2009-12-04 00:00:00 |  |  | 1 | 1 |  |  |  |  | 2009-12-06 00:00:00 | 115 |  |  | Grand Total | 7 | 4 | 5 | 4 | 5 | 25
 | 2009-12-06 00:00:00 |  |  |  |  |  |  |  |  | 2009-12-07 00:00:00 | 115
 | 2009-12-07 00:00:00 |  |  |  |  |  | 1 |  |  | 2009-12-07 00:00:00 | 115
 | 2009-12-07 00:00:00 |  |  |  |  |  |  |  |  | 2009-12-07 00:00:00 | 115 | 1
 | 2009-12-07 00:00:00 |  | 1 |  |  |  |  |  |  | 2009-12-07 00:00:00 | 115
 | 2009-12-07 00:00:00 |  |  |  |  |  |  |  |  | 2009-12-07 00:00:00 | 115
 | 2009-12-07 00:00:00 |  |  | 1 |  |  |  |  |  | 2009-12-07 00:00:00 | 115
 | 2009-12-07 00:00:00 |  |  |  |  |  |  |  |  | 2009-12-08 00:00:00 | 115
 | 2009-12-08 00:00:00 |  |  |  |  |  | 1 |  |  | 2009-12-08 00:00:00 | 115 | 0.5
 | 2009-12-08 00:00:00 |  | 0.5 |  |  |  |  |  |  | 2009-12-08 00:00:00 | 115 | 0.5
 | 2009-12-08 00:00:00 |  | 0.5 |  |  |  |  |  |  | 2009-12-08 00:00:00 | 115
 | 2009-12-08 00:00:00 |  |  | 1 |  |  |  |  |  | 2009-12-08 00:00:00 | 115
 | 2009-12-08 00:00:00 |  |  |  |  |  |  |  |  | 2009-12-08 00:00:00 | 115
 | 2009-12-08 00:00:00 |  |  |  |  |  |  |  |  | 2009-12-09 00:00:00 | 115
 | 2009-12-09 00:00:00 |  |  |  |  |  |  |  |  | 2009-12-09 00:00:00 | 115
 | 2009-12-09 00:00:00 |  |  |  |  |  |  |  |  | 2009-12-09 00:00:00 | 115
 | 2009-12-09 00:00:00 |  |  |  |  |  | 1 |  |  | 2009-12-09 00:00:00 | 115 | 1
 | 2009-12-09 00:00:00 |  | 1 |  | 1 |  |  |  |  | 2009-12-09 00:00:00 | 115
 | 2009-12-09 00:00:00 |  |  |  |  |  |  |  |  | 2009-12-10 00:00:00 | 115
 | 2009-12-10 00:00:00 |  |  |  |  |  | 0.5 |  |  | 2009-12-10 00:00:00 | 115
 | 2009-12-10 00:00:00 |  |  |  |  |  | 0.5 |  |  | 2009-12-10 00:00:00 | 115 | 1
 | 2009-12-10 00:00:00 |  | 1 |  | 1 |  |  |  |  | 2009-12-10 00:00:00 | 115
 | 2009-12-10 00:00:00 |  |  |  |  |  |  |  |  | 2009-12-01 00:00:00 | 116
 |  |  |  |  |  |  |  |  |  | 2009-12-01 00:00:00 | 116
 | "115" was used 7 times, but only on 5 dates. |  |  |  |  |  |  |  |  | 2009-12-01 00:00:00 | 116
 |  |  |  |  |  |  |  |  |  | 2009-12-02 00:00:00 | 116
 |  |  |  |  |  |  |  |  |  | 2009-12-02 00:00:00 | 116
 |  |  |  |  |  |  |  |  |  | 2009-12-02 00:00:00 | 116
 |  |  |  |  |  |  |  |  |  | 2009-12-03 00:00:00 | 116 | 1
 |  |  |  |  |  |  |  |  |  | 2009-12-03 00:00:00 | 116
 |  |  |  |  |  |  |  |  |  | 2009-12-03 00:00:00 | 116
 |  |  |  |  |  |  |  |  |  | 2009-12-04 00:00:00 | 116
 |  |  |  |  |  |  |  |  |  | 2009-12-04 00:00:00 | 116 | 1
 |  |  |  |  |  |  |  |  |  | 2009-12-06 00:00:00 | 116
 |  |  |  |  |  |  |  |  |  | 2009-12-07 00:00:00 | 116
 |  |  |  |  |  |  |  |  |  | 2009-12-07 00:00:00 | 116
 |  |  |  |  |  |  |  |  |  | 2009-12-07 00:00:00 | 116
 |  |  |  |  |  |  |  |  |  | 2009-12-07 00:00:00 | 116
 |  |  |  |  |  |  |  |  |  | 2009-12-07 00:00:00 | 116 | 1
 |  |  |  |  |  |  |  |  |  | 2009-12-07 00:00:00 | 116
 |  |  |  |  |  |  |  |  |  | 2009-12-08 00:00:00 | 116
 |  |  |  |  |  |  |  |  |  | 2009-12-08 00:00:00 | 116
 |  |  |  |  |  |  |  |  |  | 2009-12-08 00:00:00 | 116
 |  |  |  |  |  |  |  |  |  | 2009-12-08 00:00:00 | 116 | 1
 |  |  |  |  |  |  |  |  |  | 2009-12-08 00:00:00 | 116
 |  |  |  |  |  |  |  |  |  | 2009-12-08 00:00:00 | 116
 |  |  |  |  |  |  |  |  |  | 2009-12-09 00:00:00 | 116
 |  |  |  |  |  |  |  |  |  | 2009-12-09 00:00:00 | 116
 |  |  |  |  |  |  |  |  |  | 2009-12-09 00:00:00 | 116
 |  |  |  |  |  |  |  |  |  | 2009-12-09 00:00:00 | 116
 |  |  |  |  |  |  |  |  |  | 2009-12-09 00:00:00 | 116
 |  |  |  |  |  |  |  |  |  | 2009-12-10 00:00:00 | 116
 |  |  |  |  |  |  |  |  |  | 2009-12-10 00:00:00 | 116
 |  |  |  |  |  |  |  |  |  | 2009-12-10 00:00:00 | 116
 |  |  |  |  |  |  |  |  |  | 2009-12-10 00:00:00 | 116
 |  |  |  |  |  |  |  |  |  | 2009-12-01 00:00:00 | 117
 |  |  |  |  |  |  |  |  |  | 2009-12-01 00:00:00 | 117
 |  |  |  |  |  |  |  |  |  | 2009-12-01 00:00:00 | 117
 |  |  |  |  |  |  |  |  |  | 2009-12-02 00:00:00 | 117
 |  |  |  |  |  |  |  |  |  | 2009-12-02 00:00:00 | 117
 |  |  |  |  |  |  |  |  |  | 2009-12-02 00:00:00 | 117 | 0.5
 |  |  |  |  |  |  |  |  |  | 2009-12-03 00:00:00 | 117 | 0.5
 |  |  |  |  |  |  |  |  |  | 2009-12-03 00:00:00 | 117
 |  |  |  |  |  |  |  |  |  | 2009-12-03 00:00:00 | 117
 |  |  |  |  |  |  |  |  |  | 2009-12-04 00:00:00 | 117
 |  |  |  |  |  |  |  |  |  | 2009-12-04 00:00:00 | 117 | 1
 |  |  |  |  |  |  |  |  |  | 2009-12-06 00:00:00 | 117
 |  |  |  |  |  |  |  |  |  | 2009-12-07 00:00:00 | 117
 |  |  |  |  |  |  |  |  |  | 2009-12-07 00:00:00 | 117
 |  |  |  |  |  |  |  |  |  | 2009-12-07 00:00:00 | 117
 |  |  |  |  |  |  |  |  |  | 2009-12-07 00:00:00 | 117
 |  |  |  |  |  |  |  |  |  | 2009-12-07 00:00:00 | 117
 |  |  |  |  |  |  |  |  |  | 2009-12-07 00:00:00 | 117
 |  |  |  |  |  |  |  |  |  | 2009-12-08 00:00:00 | 117
 |  |  |  |  |  |  |  |  |  | 2009-12-08 00:00:00 | 117
 |  |  |  |  |  |  |  |  |  | 2009-12-08 00:00:00 | 117
 |  |  |  |  |  |  |  |  |  | 2009-12-08 00:00:00 | 117
 |  |  |  |  |  |  |  |  |  | 2009-12-08 00:00:00 | 117
 |  |  |  |  |  |  |  |  |  | 2009-12-08 00:00:00 | 117
 |  |  |  |  |  |  |  |  |  | 2009-12-09 00:00:00 | 117
 |  |  |  |  |  |  |  |  |  | 2009-12-09 00:00:00 | 117
 |  |  |  |  |  |  |  |  |  | 2009-12-09 00:00:00 | 117
 |  |  |  |  |  |  |  |  |  | 2009-12-09 00:00:00 | 117 | 1
 |  |  |  |  |  |  |  |  |  | 2009-12-09 00:00:00 | 117
 |  |  |  |  |  |  |  |  |  | 2009-12-10 00:00:00 | 117
 |  |  |  |  |  |  |  |  |  | 2009-12-10 00:00:00 | 117
 |  |  |  |  |  |  |  |  |  | 2009-12-10 00:00:00 | 117 | 1
 |  |  |  |  |  |  |  |  |  | 2009-12-10 00:00:00 | 117
 |  |  |  |  |  |  |  |  |  | 2009-12-01 00:00:00 | 118 | 1
 |  |  |  |  |  |  |  |  |  | 2009-12-01 00:00:00 | 118
 |  |  |  |  |  |  |  |  |  | 2009-12-01 00:00:00 | 118
 |  |  |  |  |  |  |  |  |  | 2009-12-02 00:00:00 | 118 | 1
 |  |  |  |  |  |  |  |  |  | 2009-12-02 00:00:00 | 118
 |  |  |  |  |  |  |  |  |  | 2009-12-02 00:00:00 | 118
 |  |  |  |  |  |  |  |  |  | 2009-12-03 00:00:00 | 118
 |  |  |  |  |  |  |  |  |  | 2009-12-03 00:00:00 | 118
 |  |  |  |  |  |  |  |  |  | 2009-12-03 00:00:00 | 118 | 1
 |  |  |  |  |  |  |  |  |  | 2009-12-04 00:00:00 | 118 | 1
 |  |  |  |  |  |  |  |  |  | 2009-12-04 00:00:00 | 118
 |  |  |  |  |  |  |  |  |  | 2009-12-06 00:00:00 | 118
 |  |  |  |  |  |  |  |  |  | 2009-12-07 00:00:00 | 118
 |  |  |  |  |  |  |  |  |  | 2009-12-07 00:00:00 | 118
 |  |  |  |  |  |  |  |  |  | 2009-12-07 00:00:00 | 118
 |  |  |  |  |  |  |  |  |  | 2009-12-07 00:00:00 | 118
 |  |  |  |  |  |  |  |  |  | 2009-12-07 00:00:00 | 118
 |  |  |  |  |  |  |  |  |  | 2009-12-07 00:00:00 | 118
 |  |  |  |  |  |  |  |  |  | 2009-12-08 00:00:00 | 118
 |  |  |  |  |  |  |  |  |  | 2009-12-08 00:00:00 | 118
 |  |  |  |  |  |  |  |  |  | 2009-12-08 00:00:00 | 118
 |  |  |  |  |  |  |  |  |  | 2009-12-08 00:00:00 | 118
 |  |  |  |  |  |  |  |  |  | 2009-12-08 00:00:00 | 118
 |  |  |  |  |  |  |  |  |  | 2009-12-08 00:00:00 | 118
 |  |  |  |  |  |  |  |  |  | 2009-12-09 00:00:00 | 118
 |  |  |  |  |  |  |  |  |  | 2009-12-09 00:00:00 | 118
 |  |  |  |  |  |  |  |  |  | 2009-12-09 00:00:00 | 118
 |  |  |  |  |  |  |  |  |  | 2009-12-09 00:00:00 | 118
 |  |  |  |  |  |  |  |  |  | 2009-12-09 00:00:00 | 118
 |  |  |  |  |  |  |  |  |  | 2009-12-10 00:00:00 | 118
 |  |  |  |  |  |  |  |  |  | 2009-12-10 00:00:00 | 118
 |  |  |  |  |  |  |  |  |  | 2009-12-10 00:00:00 | 118
 |  |  |  |  |  |  |  |  |  | 2009-12-10 00:00:00 | 118
 |  |  |  |  |  |  |  |  |  | 2009-12-01 00:00:00 | 121
 |  |  |  |  |  |  |  |  |  | 2009-12-01 00:00:00 | 121
 |  |  |  |  |  |  |  |  |  | 2009-12-01 00:00:00 | 121
 |  |  |  |  |  |  |  |  |  | 2009-12-02 00:00:00 | 121
 |  |  |  |  |  |  |  |  |  | 2009-12-02 00:00:00 | 121
 |  |  |  |  |  |  |  |  |  | 2009-12-02 00:00:00 | 121
 |  |  |  |  |  |  |  |  |  | 2009-12-03 00:00:00 | 121
 |  |  |  |  |  |  |  |  |  | 2009-12-03 00:00:00 | 121
 |  |  |  |  |  |  |  |  |  | 2009-12-03 00:00:00 | 121
 |  |  |  |  |  |  |  |  |  | 2009-12-04 00:00:00 | 121
 |  |  |  |  |  |  |  |  |  | 2009-12-04 00:00:00 | 121
 |  |  |  |  |  |  |  |  |  | 2009-12-06 00:00:00 | 121
 |  |  |  |  |  |  |  |  |  | 2009-12-07 00:00:00 | 121 | 1
 |  |  |  |  |  |  |  |  |  | 2009-12-07 00:00:00 | 121
 |  |  |  |  |  |  |  |  |  | 2009-12-07 00:00:00 | 121
 |  |  |  |  |  |  |  |  |  | 2009-12-07 00:00:00 | 121
 |  |  |  |  |  |  |  |  |  | 2009-12-07 00:00:00 | 121
 |  |  |  |  |  |  |  |  |  | 2009-12-07 00:00:00 | 121
 |  |  |  |  |  |  |  |  |  | 2009-12-08 00:00:00 | 121 | 1
 |  |  |  |  |  |  |  |  |  | 2009-12-08 00:00:00 | 121
 |  |  |  |  |  |  |  |  |  | 2009-12-08 00:00:00 | 121
 |  |  |  |  |  |  |  |  |  | 2009-12-08 00:00:00 | 121
 |  |  |  |  |  |  |  |  |  | 2009-12-08 00:00:00 | 121
 |  |  |  |  |  |  |  |  |  | 2009-12-08 00:00:00 | 121
 |  |  |  |  |  |  |  |  |  | 2009-12-09 00:00:00 | 121
 |  |  |  |  |  |  |  |  |  | 2009-12-09 00:00:00 | 121
 |  |  |  |  |  |  |  |  |  | 2009-12-09 00:00:00 | 121 | 1
 |  |  |  |  |  |  |  |  |  | 2009-12-09 00:00:00 | 121
 |  |  |  |  |  |  |  |  |  | 2009-12-09 00:00:00 | 121
 |  |  |  |  |  |  |  |  |  | 2009-12-10 00:00:00 | 121 | 0.5
 |  |  |  |  |  |  |  |  |  | 2009-12-10 00:00:00 | 121 | 0.5
 |  |  |  |  |  |  |  |  |  | 2009-12-10 00:00:00 | 121
 |  |  |  |  |  |  |  |  |  | 2009-12-10 00:00:00 | 121