Spreadsheet: 155518d1336916684-excel-2007-help-with-sumif-again-and-averageif-please-help2
Sheet: Sheet1

Night | Time | Label | Number |  |  |  |  | Sum | Average
2011-12-18 00:00:00 | 08:00:00 | Vesper | 6 |  |  | 08:00:00
2011-12-18 00:00:00 | 10:00:00 | Vesper | 1 |  |  | 09:00:00
2011-12-18 00:00:00 | 12:00:00 | Molossid | 2 |  |  | 10:00:00
2011-12-18 00:00:00 | 12:00:00 | Vesper | 1 |  |  | 11:00:00
2011-12-18 00:00:00 | 13:00:00 | Vesper | 1 |  |  | 12:00:00
2011-12-18 00:00:00 | 14:00:00 | Molossid | 1 |  |  | 13:00:00
2011-12-18 00:00:00 | 15:00:00 | Molossid | 4 |  |  | 14:00:00
2011-12-19 00:00:00 | 08:00:00 | Vesper | 2 |  |  | 15:00:00
2011-12-19 00:00:00 | 09:00:00 | Vesper | 1 |  |  | 16:00:00
2011-12-19 00:00:00 | 13:00:00 | Miniop | 1 |  |  | 17:00:00
2011-12-19 00:00:00 | 13:00:00 | Molossid | 2 |  |  | 18:00:00 |  |  | 0
2011-12-20 00:00:00 | 08:00:00 | Vesper | 9 |  |  | 19:00:00 |  |  | 0
2011-12-20 00:00:00 | 09:00:00 | Vesper | 5 |  |  | 20:00:00 |  |  | 0
2011-12-20 00:00:00 | 10:00:00 | Molossid | 3 |  |  | 21:00:00 |  |  | 0
2011-12-20 00:00:00 | 10:00:00 | Vesper | 1 |  |  | 22:00:00 |  |  | 0
2011-12-20 00:00:00 | 11:00:00 | Molossid | 1 |  |  | 23:00:00 |  |  | 0
2011-12-20 00:00:00 | 11:00:00 | Vesper | 1 |  |  | 1900-01-01 00:00:00 |  |  | 0
2011-12-20 00:00:00 | 12:00:00 | Molossid | 3 |  |  | 1900-01-01 01:00:00 |  |  | 0
2011-12-20 00:00:00 | 12:00:00 | Vesper | 1 |  |  | 1900-01-01 02:00:00 |  |  | 0
2011-12-20 00:00:00 | 13:00:00 | Vesper | 5 |  |  | 1900-01-01 03:00:00 |  |  | 0
2011-12-20 00:00:00 | 14:00:00 | Molossid | 8 |  |  | 1900-01-01 04:00:00 |  |  | 0
2011-12-20 00:00:00 | 16:00:00 | Molossid | 1 |  |  | 1900-01-01 05:00:00 |  |  | 0
2011-12-20 00:00:00 | 16:00:00 | Vesper | 1 |  |  | 1900-01-01 06:00:00 |  |  | 0
2011-12-21 00:00:00 | 09:00:00 | Vesper | 1 |  |  | 1900-01-01 07:00:00 |  |  | 0
2011-12-21 00:00:00 | 10:00:00 | Molossid | 3
2011-12-21 00:00:00 | 10:00:00 | Vesper | 2
2011-12-21 00:00:00 | 11:00:00 | Molossid | 4
2011-12-21 00:00:00 | 13:00:00 | Molossid | 1
2011-12-21 00:00:00 | 14:00:00 | Molossid | 1
2011-12-21 00:00:00 | 14:00:00 | Vesper | 1
2011-12-21 00:00:00 | 16:00:00 | Vesper | 1
2011-12-22 00:00:00 | 08:00:00 | Vesper | 2
2011-12-22 00:00:00 | 09:00:00 | Vesper | 2
2011-12-22 00:00:00 | 10:00:00 | Molossid | 1
2011-12-22 00:00:00 | 11:00:00 | Molossid | 2
2011-12-22 00:00:00 | 12:00:00 | Molossid | 2
2011-12-22 00:00:00 | 14:00:00 | Molossid | 1
2011-12-23 00:00:00 | 08:00:00 | Molossid | 1
2011-12-23 00:00:00 | 08:00:00 | Vesper | 4
2011-12-23 00:00:00 | 09:00:00 | Molossid | 2
2011-12-23 00:00:00 | 11:00:00 | Molossid | 1
2011-12-23 00:00:00 | 12:00:00 | Vesper | 1
2011-12-24 00:00:00 | 08:00:00 | Vesper | 1
2011-12-24 00:00:00 | 09:00:00 | Molossid | 2
2011-12-24 00:00:00 | 10:00:00 | Molossid | 1
2011-12-24 00:00:00 | 11:00:00 | Molossid | 1
2011-12-24 00:00:00 | 12:00:00 | Vesper | 1
2011-12-24 00:00:00 | 13:00:00 | Miniop | 1
2011-12-24 00:00:00 | 14:00:00 | Molossid | 1
2011-12-25 00:00:00 | 08:00:00 | Molossid | 3
2011-12-25 00:00:00 | 09:00:00 | Molossid | 5
2011-12-25 00:00:00 | 09:00:00 | Vesper | 2
2011-12-25 00:00:00 | 10:00:00 | Molossid | 14
2011-12-25 00:00:00 | 10:00:00 | Vesper | 11
2011-12-25 00:00:00 | 11:00:00 | Molossid | 23
2011-12-25 00:00:00 | 11:00:00 | Vesper | 24
2011-12-25 00:00:00 | 13:00:00 | Molossid | 1
2011-12-25 00:00:00 | 14:00:00 | Vesper | 1
2011-12-25 00:00:00 | 15:00:00 | Molossid | 21
2011-12-25 00:00:00 | 15:00:00 | Vesper | 38
2011-12-25 00:00:00 | 16:00:00 | Molossid | 5
2011-12-25 00:00:00 | 16:00:00 | Vesper | 3
2011-12-26 00:00:00 | 05:00:00 | Molossid | 8
2011-12-26 00:00:00 | 05:00:00 | Vesper | 1
2011-12-26 00:00:00 | 08:00:00 | Molossid | 1
2011-12-26 00:00:00 | 08:00:00 | Vesper | 5
2011-12-26 00:00:00 | 10:00:00 | Vesper | 1
2011-12-26 00:00:00 | 11:00:00 | Vesper | 1
2011-12-26 00:00:00 | 12:00:00 | Molossid | 3
2011-12-26 00:00:00 | 12:00:00 | Vesper | 11
2011-12-26 00:00:00 | 15:00:00 | Molossid | 4
2011-12-26 00:00:00 | 15:00:00 | Vesper | 1
2011-12-27 00:00:00 | 08:00:00 | Vesper | 5
2011-12-27 00:00:00 | 09:00:00 | Molossid | 1
2011-12-27 00:00:00 | 09:00:00 | Vesper | 2
2011-12-27 00:00:00 | 11:00:00 | Vesper | 1
2011-12-27 00:00:00 | 12:00:00 | Molossid | 1
2011-12-27 00:00:00 | 13:00:00 | Molossid | 1
2011-12-27 00:00:00 | 13:00:00 | Vesper | 1
2011-12-27 00:00:00 | 15:00:00 | Vesper | 3
2011-12-27 00:00:00 | 16:00:00 | Vesper | 1
2011-12-28 00:00:00 | 08:00:00 | Vesper | 1
2011-12-28 00:00:00 | 10:00:00 | Molossid | 1
2011-12-28 00:00:00 | 10:00:00 | Vesper | 1
2011-12-28 00:00:00 | 11:00:00 | Molossid | 1
2011-12-28 00:00:00 | 12:00:00 | Molossid | 1
2011-12-28 00:00:00 | 13:00:00 | Vesper | 1
2011-12-28 00:00:00 | 17:00:00 | Vesper | 1
2011-12-29 00:00:00 | 08:00:00 | Vesper | 3
2011-12-29 00:00:00 | 09:00:00 | Molossid | 1
2011-12-29 00:00:00 | 09:00:00 | Vesper | 13
2011-12-29 00:00:00 | 11:00:00 | Vesper | 2
2011-12-29 00:00:00 | 13:00:00 | Miniop | 1
2011-12-30 00:00:00 | 08:00:00 | Vesper | 2
2011-12-30 00:00:00 | 09:00:00 | Molossid | 1
2011-12-30 00:00:00 | 09:00:00 | Vesper | 2
2011-12-30 00:00:00 | 10:00:00 | Vesper | 1
2011-12-30 00:00:00 | 11:00:00 | Molossid | 4
2011-12-30 00:00:00 | 12:00:00 | Molossid | 2
2011-12-30 00:00:00 | 13:00:00 | Molossid | 1
2011-12-30 00:00:00 | 14:00:00 | Molossid | 4
2011-12-30 00:00:00 | 17:00:00 | Molossid | 1
2011-12-31 00:00:00 | 08:00:00 | Molossid | 2
2011-12-31 00:00:00 | 08:00:00 | Vesper | 4
2011-12-31 00:00:00 | 09:00:00 | Vesper | 7
2011-12-31 00:00:00 | 12:00:00 | Molossid | 6
2011-12-31 00:00:00 | 12:00:00 | Vesper | 1
2011-12-31 00:00:00 | 13:00:00 | Molossid | 1
2011-12-31 00:00:00 | 14:00:00 | Molossid | 6
2011-12-31 00:00:00 | 15:00:00 | Molossid | 1
2011-12-31 00:00:00 | 16:00:00 | Vesper | 1
2012-01-01 00:00:00 | 13:00:00 | Molossid | 2
2012-01-01 00:00:00 | 14:00:00 | Molossid | 1
2012-01-02 00:00:00 | 09:00:00 | Vesper | 2
2012-01-02 00:00:00 | 11:00:00 | Molossid | 1
2012-01-02 00:00:00 | 12:00:00 | Molossid | 2
2012-01-02 00:00:00 | 13:00:00 | Molossid | 1
2012-01-02 00:00:00 | 14:00:00 | Molossid | 1
2012-01-02 00:00:00 | 15:00:00 | Molossid | 1
2012-01-03 00:00:00 | 08:00:00 | Vesper | 2
2012-01-03 00:00:00 | 11:00:00 | Vesper | 1
2012-01-03 00:00:00 | 13:00:00 | Vesper | 1
2012-01-03 00:00:00 | 14:00:00 | Molossid | 1
2012-01-03 00:00:00 | 15:00:00 | Molossid | 2
2012-01-04 00:00:00 | 09:00:00 | Molossid | 3
2012-01-04 00:00:00 | 10:00:00 | Molossid | 1
2012-01-04 00:00:00 | 11:00:00 | Miniop | 1
2012-01-04 00:00:00 | 11:00:00 | Molossid | 1
2012-01-04 00:00:00 | 12:00:00 | Miniop | 1
2012-01-04 00:00:00 | 12:00:00 | Molossid | 1
2012-01-04 00:00:00 | 13:00:00 | Molossid | 1
2012-01-05 00:00:00 | 09:00:00 | Vesper | 2
2012-01-05 00:00:00 | 11:00:00 | Miniop | 1
2012-01-05 00:00:00 | 13:00:00 | Molossid | 1
2012-01-06 00:00:00 | 08:00:00 | Vesper | 1
2012-01-06 00:00:00 | 09:00:00 | Miniop | 1
2012-01-06 00:00:00 | 14:00:00 | Miniop | 1
2012-01-06 00:00:00 | 15:00:00 | Molossid | 2
2012-01-07 00:00:00 | 08:00:00 | Vesper | 3
2012-01-07 00:00:00 | 09:00:00 | Vesper | 5
2012-01-07 00:00:00 | 10:00:00 | Molossid | 1
2012-01-07 00:00:00 | 10:00:00 | Vesper | 1
2012-01-07 00:00:00 | 11:00:00 | Miniop | 1
2012-01-07 00:00:00 | 11:00:00 | Vesper | 1
2012-01-07 00:00:00 | 12:00:00 | Vesper | 2
2012-01-07 00:00:00 | 16:00:00 | Vesper | 2
2012-01-08 00:00:00 | 08:00:00 | Vesper | 1
2012-01-08 00:00:00 | 09:00:00 | Vesper | 1
2012-01-08 00:00:00 | 12:00:00 | Vesper | 2
2012-01-08 00:00:00 | 14:00:00 | Molossid | 1
2012-01-08 00:00:00 | 14:00:00 | Vesper | 2
2012-01-08 00:00:00 | 15:00:00 | Vesper | 2
2012-01-08 00:00:00 | 16:00:00 | Vesper | 1
2012-01-09 00:00:00 | 08:00:00 | Vesper | 1
2012-01-09 00:00:00 | 12:00:00 | Vesper | 1
2012-01-09 00:00:00 | 14:00:00 | Molossid | 1
2012-01-09 00:00:00 | 14:00:00 | Vesper | 1
2012-01-09 00:00:00 | 15:00:00 | Molossid | 1
2012-01-09 00:00:00 | 16:00:00 | Vesper | 1
2012-01-10 00:00:00 | 15:00:00 | Molossid | 1
2012-01-10 00:00:00 | 17:00:00 | Molossid | 1
2012-01-11 00:00:00 | 10:00:00 | Molossid | 1
2012-01-11 00:00:00 | 10:00:00 | Vesper | 1
2012-01-11 00:00:00 | 11:00:00 | Vesper | 1
2012-01-11 00:00:00 | 12:00:00 | Vesper | 1
2012-01-11 00:00:00 | 14:00:00 | Molossid | 1
2012-01-11 00:00:00 | 14:00:00 | Vesper | 5
2012-01-11 00:00:00 | 15:00:00 | Vesper | 1
2012-01-11 00:00:00 | 16:00:00 | Molossid | 1
2012-01-11 00:00:00 | 16:00:00 | Vesper | 5
2012-01-12 00:00:00 | 08:00:00 | Molossid | 2
2012-01-12 00:00:00 | 10:00:00 | Molossid | 2
2012-01-12 00:00:00 | 11:00:00 | Molossid | 1
2012-01-12 00:00:00 | 11:00:00 | Vesper | 1
2012-01-12 00:00:00 | 14:00:00 | Molossid | 1
2012-01-12 00:00:00 | 14:00:00 | Vesper | 1
2012-01-12 00:00:00 | 16:00:00 | Vesper | 2
2012-01-13 00:00:00 | 11:00:00 | Vesper | 1
2012-01-13 00:00:00 | 12:00:00 | Vesper | 1
2012-01-13 00:00:00 | 13:00:00 | Molossid | 1
2012-01-14 00:00:00 | 08:00:00 | Molossid | 4
2012-01-14 00:00:00 | 09:00:00 | Molossid | 6
2012-01-14 00:00:00 | 10:00:00 | Molossid | 1
2012-01-14 00:00:00 | 10:00:00 | Vesper | 2
2012-01-14 00:00:00 | 11:00:00 | Molossid | 2
2012-01-14 00:00:00 | 11:00:00 | Vesper | 3
2012-01-14 00:00:00 | 12:00:00 | Molossid | 1
2012-01-14 00:00:00 | 14:00:00 | Miniop | 1
2012-01-14 00:00:00 | 15:00:00 | Molossid | 1
2012-01-14 00:00:00 | 16:00:00 | Vesper | 5
2012-01-15 00:00:00 | 13:00:00 | Molossid | 1
2012-01-16 00:00:00 | 08:00:00 | Molossid | 1
2012-01-16 00:00:00 | 10:00:00 | Vesper | 2
2012-01-16 00:00:00 | 12:00:00 | Molossid | 2
2012-01-16 00:00:00 | 12:00:00 | Vesper | 31
2012-01-16 00:00:00 | 13:00:00 | Vesper | 3
2012-01-16 00:00:00 | 14:00:00 | Molossid | 2
2012-01-16 00:00:00 | 15:00:00 | Molossid | 3
2012-01-16 00:00:00 | 15:00:00 | Vesper | 1
2012-01-16 00:00:00 | 16:00:00 | Molossid | 1
2012-01-17 00:00:00 | 09:00:00 | Molossid | 3
2012-01-17 00:00:00 | 09:00:00 | Vesper | 1
2012-01-17 00:00:00 | 10:00:00 | Molossid | 1
2012-01-17 00:00:00 | 10:00:00 | Vesper | 3
2012-01-17 00:00:00 | 13:00:00 | Molossid | 2
2012-01-17 00:00:00 | 14:00:00 | Molossid | 5
2012-01-17 00:00:00 | 15:00:00 | Molossid | 4
2012-01-17 00:00:00 | 16:00:00 | Vesper | 10
2012-01-18 00:00:00 | 08:00:00 | Molossid | 1
2012-01-18 00:00:00 | 08:00:00 | Vesper | 3
2012-01-18 00:00:00 | 09:00:00 | Molossid | 2
2012-01-18 00:00:00 | 09:00:00 | Vesper | 3
2012-01-18 00:00:00 | 10:00:00 | Vesper | 5
2012-01-18 00:00:00 | 11:00:00 | Vesper | 2
2012-01-18 00:00:00 | 12:00:00 | Vesper | 3
2012-01-18 00:00:00 | 13:00:00 | Molossid | 1
2012-01-18 00:00:00 | 13:00:00 | Vesper | 4
2012-01-18 00:00:00 | 14:00:00 | Molossid | 1
2012-01-18 00:00:00 | 14:00:00 | Vesper | 4
2012-01-18 00:00:00 | 15:00:00 | Molossid | 1
2012-01-19 00:00:00 | 08:00:00 | Molossid | 3
2012-01-19 00:00:00 | 08:00:00 | Vesper | 1
2012-01-19 00:00:00 | 09:00:00 | Molossid | 2
2012-01-19 00:00:00 | 09:00:00 | Vesper | 5
2012-01-19 00:00:00 | 10:00:00 | Molossid | 5
2012-01-19 00:00:00 | 10:00:00 | Vesper | 3
2012-01-19 00:00:00 | 11:00:00 | Molossid | 7
2012-01-19 00:00:00 | 12:00:00 | Vesper | 1
2012-01-19 00:00:00 | 13:00:00 | Molossid | 1
2012-01-19 00:00:00 | 13:00:00 | Vesper | 5
2012-01-19 00:00:00 | 14:00:00 | Molossid | 2
2012-01-19 00:00:00 | 14:00:00 | Vesper | 6
2012-01-19 00:00:00 | 15:00:00 | Molossid | 3
2012-01-20 00:00:00 | 08:00:00 | Molossid | 2
2012-01-20 00:00:00 | 08:00:00 | Vesper | 3
2012-01-20 00:00:00 | 09:00:00 | Molossid | 2
2012-01-20 00:00:00 | 11:00:00 | Molossid | 2
2012-01-20 00:00:00 | 13:00:00 | Molossid | 1
2012-01-20 00:00:00 | 14:00:00 | Molossid | 6
2012-01-21 00:00:00 | 11:00:00 | Molossid | 1
2012-01-21 00:00:00 | 11:00:00 | Vesper | 2
2012-01-21 00:00:00 | 12:00:00 | Molossid | 1
2012-01-21 00:00:00 | 13:00:00 | Molossid | 2
2012-01-22 00:00:00 | 08:00:00 | Molossid | 1
2012-01-22 00:00:00 | 09:00:00 | Vesper | 1
2012-01-22 00:00:00 | 10:00:00 | Molossid | 1
2012-01-22 00:00:00 | 11:00:00 | Molossid | 1
2012-01-22 00:00:00 | 14:00:00 | Molossid | 2
2012-01-22 00:00:00 | 14:00:00 | Vesper | 1
2012-01-22 00:00:00 | 15:00:00 | Molossid | 2
2012-01-22 00:00:00 | 16:00:00 | Vesper | 2
2012-01-23 00:00:00 | 09:00:00 | Molossid | 1
2012-01-23 00:00:00 | 09:00:00 | Vesper | 1
2012-01-23 00:00:00 | 10:00:00 | Molossid | 3
2012-01-23 00:00:00 | 11:00:00 | Molossid | 2
2012-01-23 00:00:00 | 11:00:00 | Vesper | 1
2012-01-23 00:00:00 | 12:00:00 | Vesper | 1
2012-01-23 00:00:00 | 13:00:00 | Molossid | 2
2012-01-23 00:00:00 | 14:00:00 | Molossid | 2
2012-01-24 00:00:00 | 08:00:00 | Molossid | 1
2012-01-24 00:00:00 | 09:00:00 | Molossid | 2
2012-01-24 00:00:00 | 09:00:00 | Vesper | 2
2012-01-24 00:00:00 | 10:00:00 | Vesper | 1
2012-01-24 00:00:00 | 11:00:00 | Vesper | 2
2012-01-24 00:00:00 | 12:00:00 | Vesper | 1
2012-01-26 00:00:00 | 09:00:00 | Miniop | 1
2012-01-26 00:00:00 | 09:00:00 | Molossid | 2
2012-01-26 00:00:00 | 10:00:00 | Molossid | 1
2012-01-26 00:00:00 | 10:00:00 | Vesper | 3
2012-01-26 00:00:00 | 11:00:00 | Molossid | 2
2012-01-26 00:00:00 | 12:00:00 | Molossid | 1
2012-01-26 00:00:00 | 13:00:00 | Molossid | 1
2012-01-26 00:00:00 | 14:00:00 | Molossid | 7
2012-01-26 00:00:00 | 14:00:00 | Vesper | 1
2012-01-26 00:00:00 | 15:00:00 | Molossid | 2
2012-01-27 00:00:00 | 11:00:00 | Molossid | 1
2012-01-27 00:00:00 | 13:00:00 | Molossid | 1
2012-01-27 00:00:00 | 14:00:00 | Molossid | 8
2012-01-28 00:00:00 | 09:00:00 | Vesper | 1
2012-01-28 00:00:00 | 10:00:00 | Vesper | 1
2012-01-28 00:00:00 | 11:00:00 | Vesper | 1
2012-01-28 00:00:00 | 12:00:00 | Molossid | 1
2012-01-28 00:00:00 | 13:00:00 | Molossid | 5
2012-01-28 00:00:00 | 14:00:00 | Molossid | 5
2012-01-28 00:00:00 | 15:00:00 | Molossid | 2
2012-01-28 00:00:00 | 15:00:00 | Vesper | 1
2012-01-29 00:00:00 | 09:00:00 | Vesper | 2
2012-01-29 00:00:00 | 10:00:00 | Molossid | 1
2012-01-29 00:00:00 | 10:00:00 | Vesper | 1
2012-01-29 00:00:00 | 12:00:00 | Molossid | 1
2012-01-29 00:00:00 | 13:00:00 | Molossid | 1
2012-01-29 00:00:00 | 13:00:00 | Vesper | 1
2012-01-29 00:00:00 | 15:00:00 | Molossid | 7
2012-01-29 00:00:00 | 16:00:00 | Molossid | 3
2012-01-30 00:00:00 | 11:00:00 | Molossid | 3
2012-01-30 00:00:00 | 11:00:00 | Vesper | 1
2012-01-30 00:00:00 | 12:00:00 | Molossid | 5
2012-01-30 00:00:00 | 13:00:00 | Molossid | 4
2012-01-30 00:00:00 | 14:00:00 | Molossid | 3
2012-01-30 00:00:00 | 16:00:00 | Molossid | 1
2012-01-31 00:00:00 | 08:00:00 | Molossid | 1
2012-01-31 00:00:00 | 09:00:00 | Molossid | 4
2012-01-31 00:00:00 | 09:00:00 | Vesper | 1
2012-01-31 00:00:00 | 10:00:00 | Molossid | 2
2012-01-31 00:00:00 | 12:00:00 | Molossid | 1
2012-01-31 00:00:00 | 12:00:00 | Vesper | 1
2012-01-31 00:00:00 | 13:00:00 | Molossid | 2
2012-01-31 00:00:00 | 14:00:00 | Molossid | 1
2012-01-31 00:00:00 | 15:00:00 | Molossid | 1
2012-02-01 00:00:00 | 06:00:00 | Molossid | 7
2012-02-01 00:00:00 | 06:00:00 | Vesper | 1
2012-02-01 00:00:00 | 08:00:00 | Molossid | 4
2012-02-01 00:00:00 | 08:00:00 | Vesper | 5
2012-02-01 00:00:00 | 09:00:00 | Molossid | 1
2012-02-01 00:00:00 | 09:00:00 | Vesper | 2
2012-02-01 00:00:00 | 11:00:00 | Vesper | 3
2012-02-01 00:00:00 | 13:00:00 | Molossid | 4
2012-02-01 00:00:00 | 13:00:00 | Vesper | 3
2012-02-01 00:00:00 | 14:00:00 | Vesper | 9