Spreadsheet: 152445d1335383459-formula-to-count-based-on-mult-criteria-example
Sheet: Sheet2

 |  |  | Required Resources
Start Date Time  (dd/mm/yyyy hh:[NAME]) | End Date Time  (dd/mm/yyyy hh:[NAME]) | Duration (hh:[NAME]) | Resource 1 | Resource 2 | Resource 3 | Resource 4 | Resource 5 | Resource 6 | Resource 7 | Resource 8 | Resource 9 | Resource 10 | Resource 11 | Resource 12 | Resource 13 | Resource 14 | Resource 15 | Resource 16 | Resource 17 | Resource 18 | Resource 19 | Resource 20 | Resource 21 | Resource 22 | Resource 23 | Resource 24 | Resource 25 | Resource 26
2012-06-01 00:00:00 | 2012-06-01 00:00:00 | 00:00:00
2012-09-01 00:00:00 | 2012-09-01 00:00:00 | 00:00:00
2012-07-02 00:00:00 | 2012-07-02 00:00:00 | 00:00:00
2012-07-02 00:00:00 | 2012-07-02 00:00:00 | 00:00:00
2012-10-05 00:00:00 | 2012-10-05 00:00:00 | 00:00:00 |  |  | Y |  |  | Y |  |  | Y |  |  |  | Y
2012-07-02 00:00:00 | 2012-07-02 00:00:00 | 00:00:00
2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 00:00:00
2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 00:00:00 |  |  | Y
2012-10-05 00:00:00 | 2012-10-05 00:00:00 | 00:00:00 |  |  | Y
2013-01-01 00:00:00 | 2013-01-01 00:00:00 | 00:00:00 |  |  | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
2012-03-01 00:00:00 | 2012-03-01 00:00:00 | 00:00:00 |  |  | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
2013-05-11 00:00:00 | 2013-05-11 00:00:00 | 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
2012-10-05 00:00:00 | 2012-10-05 00:00:00 | 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
2012-07-10 00:00:00 | 2012-07-10 00:00:00 | 00:00:00 |  |  | Y
2012-10-08 00:00:00 | 2012-10-08 00:00:00 | 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
2012-06-30 00:00:00 | 2012-06-30 00:00:00 | 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
2012-10-05 00:00:00 | 2012-10-05 00:00:00 | 00:00:00 |  |  | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
2012-10-05 00:00:00 | 2012-10-05 00:00:00 | 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
2012-06-09 00:00:00 | 2012-06-09 00:00:00 | 00:00:00 |  |  | Y |  |  |  |  |  |  |  |  |  |  |  |  | Y |  | Y |  |  |  |  | Y
2012-10-05 00:00:00 | 2012-10-05 00:00:00 | 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
2012-10-08 00:00:00 | 2012-10-08 00:00:00 | 00:00:00
2012-10-08 00:00:00 | 2012-10-08 00:00:00 | 00:00:00 |  |  | Y |  |  |  |  |  |  |  |  |  |  |  |  | Y
2012-06-09 00:00:00 | 2012-06-09 00:00:00 | 00:00:00 |  |  |  |  |  |  |  |  |  | Y |  |  | Y |  |  |  |  | Y |  |  | Y
2012-10-05 00:00:00 | 2012-10-05 00:00:00 | 00:00:00
2012-10-08 00:00:00 | 2012-10-08 00:00:00 | 00:00:00 |  |  | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
2012-10-05 00:00:00 | 2012-10-05 00:00:00 | 00:00:00 |  |  |  |  |  |  |  |  |  | Y |  | Y
2012-12-03 00:00:00 | 2012-12-03 00:00:00 | 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y |  |  | Y
2012-04-05 00:00:00 | 2012-06-05 00:00:00 | 00:00:00 |  |  | Y
2012-08-10 00:00:00 | 2012-08-10 00:00:00 | 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Y |  |  |  |  |  |  |  |  | Y
2012-07-06 00:00:00 | 2012-07-06 00:00:00 | 00:00:00
2012-07-07 00:00:00 | 30/07/2012 | 1900-01-23 00:00:00 |  |  | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
2012-10-05 00:00:00 | 2012-10-05 00:00:00 | 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
2012-03-03 00:00:00 | 2012-03-03 00:00:00 | 00:00:00 |  |  |  |  | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
2012-10-08 00:00:00 | 2012-10-08 00:00:00 | 00:00:00 |  |  | Y
2012-10-05 00:00:00 | 2012-10-05 00:00:00 | 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y |  |  |  | Y
2012-10-05 00:00:00 | 2012-10-05 00:00:00 | 00:00:00
2012-10-05 00:00:00 | 2012-10-05 00:00:00 | 00:00:00 |  |  | Y |  |  |  |  |  | Y |  |  | Y
2012-07-07 00:00:00 | 2012-07-07 00:00:00 | 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
2012-10-08 00:00:00 | 2012-10-08 00:00:00 | 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
2012-09-01 00:00:00 | 2012-09-01 00:00:00 | 00:00:00 |  |  | Y |  |  |  |  |  | Y |  |  |  | Y |  |  |  |  |  |  |  | Y
2012-10-05 00:00:00 | 2012-10-05 00:00:00 | 00:00:00
2012-10-08 00:00:00 | 2012-10-08 00:00:00 | 00:00:00 | Y
2012-10-08 00:00:00 | 2012-10-08 00:00:00 | 00:00:00 | Y |  |  |  |  |  |  |  | Y |  |  | Y |  |  |  |  |  | Y
2012-10-08 00:00:00 | 2012-10-08 00:00:00 | 00:00:00 | Y |  | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
2012-10-08 00:00:00 | 2012-10-08 00:00:00 | 00:00:00
2012-07-02 00:00:00 | 2012-07-02 00:00:00 | 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Y |  |  | Y
2012-10-08 00:00:00 | 2012-10-08 00:00:00 | 00:00:00 |  |  | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
2012-05-05 00:00:00 | 2012-05-05 00:00:00 | 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
2012-07-02 00:00:00 | 2012-07-02 00:00:00 | 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
2012-10-05 00:00:00 | 2012-10-05 00:00:00 | 00:00:00 |  |  | Y
2013-04-01 00:00:00 | 2013-04-01 00:00:00 | 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
2012-06-06 21:00:00 | 2012-06-06 23:30:00 | 02:30:00
2012-06-01 00:00:00 | 2012-06-01 00:00:00 | 00:00:00
2016-03-01 00:00:00 | 2016-03-01 00:00:00 | 00:00:00
2012-10-05 00:00:00 | 2012-10-05 00:00:00 | 00:00:00 |  |  |  |  |  |  | Y