Spreadsheet: 152626d1335456447-excel-2007-sumifs-help-excel-2007-help
Sheet: Data

Call Type | Total | 24:00 -01:00 | 01:00 -02:00 | 02:00 -03:00 | 03:00 -04:00 | 04:00 -05:00 | 05:00 -06:00 | 06:00 -07:00 | 07:00 -08:00 | 08:00 -09:00 | 09:00 -10:00 | 10:00 -11:00 | 11:00 -12:00 | 12:00 -13:00 | 13:00 -14:00 | 14:00 -15:00 | 15:00 -16:00 | 16:00 -17:00 | 17:00 -18:00 | 18:00 -19:00 | 19:00 -20:00 | 20:00 -21:00 | 21:00 -22:00 | 22:00 -23:00 | 23:00 -24:00
2012-01-02 00:00:00
[NAME] | 33 | 0 | 0 | 0 | 0 | 1 | 3 | 4 | 5 | 7 | 2 | 0 | 0 | 4 | 0 | 4 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
[NAME] | 77 | 0 | 0 | 1 | 1 | 4 | 4 | 7 | 9 | 10 | 4 | 9 | 7 | 4 | 3 | 4 | 5 | 0 | 0 | 2 | 0 | 1 | 0 | 0 | 2
Tech | 195 | 1 | 0 | 0 | 0 | 3 | 4 | 10 | 19 | 29 | 23 | 12 | 20 | 14 | 23 | 13 | 12 | 4 | 2 | 0 | 3 | 1 | 0 | 1 | 1
2012-01-03 00:00:00
[NAME] | 115 | 0 | 1 | 0 | 0 | 0 | 1 | 9 | 18 | 11 | 25 | 9 | 11 | 16 | 6 | 3 | 0 | 0 | 0 | 2 | 1 | 2 | 0 | 0 | 0
[NAME] | 109 | 0 | 3 | 0 | 0 | 1 | 5 | 5 | 6 | 7 | 8 | 8 | 13 | 9 | 7 | 8 | 9 | 6 | 3 | 6 | 1 | 0 | 0 | 3 | 1
Tech | 201 | 0 | 3 | 0 | 0 | 0 | 4 | 4 | 19 | 19 | 17 | 23 | 14 | 13 | 17 | 24 | 16 | 10 | 8 | 4 | 3 | 2 | 1 | 0 | 0
2012-01-04 00:00:00
[NAME] | 105 | 1 | 1 | 0 | 0 | 0 | 5 | 7 | 5 | 10 | 16 | 7 | 4 | 11 | 11 | 7 | 9 | 4 | 3 | 3 | 0 | 0 | 1 | 0 | 0
[NAME] | 106 | 1 | 0 | 1 | 0 | 3 | 1 | 7 | 3 | 4 | 5 | 8 | 7 | 8 | 13 | 9 | 11 | 7 | 8 | 2 | 4 | 1 | 0 | 2 | 1
Tech | 219 | 1 | 1 | 0 | 0 | 1 | 4 | 5 | 24 | 19 | 23 | 15 | 20 | 16 | 26 | 20 | 18 | 11 | 8 | 3 | 3 | 0 | 0 | 1 | 0
2012-01-05 00:00:00
[NAME] | 102 | 1 | 1 | 0 | 0 | 0 | 2 | 5 | 10 | 20 | 3 | 10 | 5 | 9 | 19 | 3 | 1 | 3 | 5 | 4 | 0 | 0 | 1 | 0 | 0
[NAME] | 89 | 0 | 1 | 0 | 0 | 3 | 1 | 4 | 7 | 12 | 10 | 7 | 10 | 8 | 11 | 3 | 4 | 0 | 4 | 3 | 0 | 0 | 1 | 0 | 0
Tech | 236 | 0 | 0 | 0 | 1 | 0 | 2 | 17 | 17 | 21 | 28 | 15 | 15 | 23 | 20 | 20 | 28 | 12 | 11 | 0 | 2 | 2 | 0 | 1 | 1
2012-01-06 00:00:00
[NAME] | 76 | 0 | 0 | 0 | 0 | 0 | 2 | 7 | 6 | 7 | 10 | 7 | 2 | 10 | 9 | 9 | 0 | 1 | 4 | 0 | 1 | 1 | 0 | 0 | 0
[NAME] | 88 | 0 | 0 | 0 | 1 | 3 | 3 | 1 | 3 | 11 | 8 | 8 | 5 | 5 | 6 | 5 | 7 | 4 | 9 | 2 | 4 | 0 | 2 | 1 | 0
Tech | 194 | 0 | 0 | 0 | 0 | 1 | 1 | 7 | 24 | 16 | 18 | 11 | 12 | 16 | 21 | 31 | 14 | 7 | 4 | 3 | 4 | 3 | 1 | 0 | 0
2012-01-07 00:00:00
[NAME] | 27 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 2 | 3 | 2 | 4 | 5 | 2 | 1 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 45 | 3 | 0 | 0 | 0 | 0 | 0 | 2 | 3 | 4 | 6 | 1 | 2 | 4 | 3 | 1 | 2 | 3 | 5 | 1 | 2 | 0 | 2 | 0 | 1
Tech | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 2 | 3 | 2 | 0 | 1 | 1 | 2 | 3 | 1 | 1 | 0 | 1 | 1 | 0
2012-01-08 00:00:00
[NAME] | 25 | 1 | 0 | 0 | 0 | 0 | 1 | 6 | 1 | 3 | 2 | 0 | 3 | 2 | 2 | 2 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 36 | 0 | 0 | 1 | 1 | 0 | 4 | 5 | 4 | 3 | 1 | 1 | 4 | 1 | 0 | 4 | 3 | 1 | 1 | 2 | 0 | 0 | 0 | 0 | 0
Tech | 28 | 0 | 0 | 0 | 0 | 1 | 2 | 2 | 0 | 1 | 0 | 2 | 2 | 1 | 1 | 4 | 1 | 1 | 2 | 2 | 3 | 2 | 0 | 1 | 0
2012-01-09 00:00:00
[NAME] | 96 | 0 | 0 | 0 | 1 | 1 | 3 | 10 | 9 | 15 | 13 | 4 | 10 | 3 | 11 | 7 | 3 | 4 | 1 | 0 | 0 | 1 | 0 | 0 | 0
[NAME] | 72 | 0 | 0 | 0 | 3 | 0 | 2 | 4 | 5 | 4 | 11 | 8 | 9 | 6 | 6 | 2 | 2 | 1 | 3 | 0 | 2 | 2 | 2 | 0 | 0
Tech | 207 | 0 | 0 | 0 | 0 | 1 | 5 | 13 | 17 | 17 | 17 | 18 | 12 | 15 | 28 | 23 | 22 | 10 | 3 | 3 | 0 | 0 | 2 | 1 | 0
2012-01-10 00:00:00
[NAME] | 89 | 0 | 0 | 0 | 0 | 2 | 5 | 9 | 6 | 8 | 6 | 12 | 6 | 8 | 5 | 1 | 13 | 2 | 3 | 0 | 1 | 0 | 1 | 1 | 0
[NAME] | 85 | 0 | 2 | 0 | 0 | 5 | 3 | 6 | 4 | 7 | 7 | 11 | 3 | 8 | 10 | 2 | 5 | 5 | 3 | 0 | 1 | 0 | 1 | 2 | 0
Tech | 176 | 0 | 0 | 1 | 0 | 1 | 0 | 10 | 9 | 2 | 20 | 17 | 18 | 18 | 18 | 17 | 25 | 12 | 2 | 0 | 3 | 3 | 0 | 0 | 0
2012-01-11 00:00:00
[NAME] | 93 | 0 | 0 | 0 | 0 | 1 | 3 | 11 | 6 | 9 | 9 | 10 | 2 | 11 | 9 | 2 | 4 | 0 | 9 | 4 | 1 | 1 | 1 | 0 | 0
[NAME] | 81 | 0 | 0 | 0 | 0 | 4 | 1 | 3 | 2 | 6 | 8 | 3 | 2 | 8 | 10 | 6 | 6 | 9 | 2 | 6 | 2 | 1 | 2 | 0 | 0
Tech | 178 | 0 | 0 | 0 | 0 | 1 | 1 | 5 | 10 | 14 | 19 | 15 | 15 | 11 | 18 | 26 | 17 | 12 | 7 | 4 | 2 | 0 | 1 | 0 | 0
2012-01-12 00:00:00
[NAME] | 53 | 0 | 0 | 0 | 0 | 0 | 2 | 8 | 7 | 7 | 5 | 7 | 5 | 3 | 4 | 2 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 107 | 0 | 0 | 0 | 2 | 3 | 4 | 5 | 11 | 4 | 11 | 12 | 8 | 9 | 13 | 7 | 1 | 1 | 1 | 3 | 11 | 0 | 1 | 0 | 0
Tech | 176 | 0 | 0 | 0 | 1 | 0 | 1 | 5 | 15 | 10 | 14 | 17 | 11 | 6 | 19 | 18 | 15 | 7 | 9 | 7 | 15 | 2 | 4 | 0 | 0
2012-01-13 00:00:00
[NAME] | 62 | 0 | 0 | 0 | 0 | 0 | 2 | 6 | 5 | 8 | 6 | 12 | 4 | 4 | 5 | 5 | 4 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 106 | 1 | 1 | 1 | 1 | 0 | 2 | 11 | 4 | 5 | 3 | 5 | 11 | 10 | 4 | 11 | 6 | 7 | 6 | 4 | 4 | 2 | 4 | 1 | 2
Tech | 201 | 0 | 3 | 0 | 0 | 0 | 0 | 7 | 15 | 14 | 26 | 14 | 28 | 15 | 14 | 17 | 22 | 11 | 3 | 5 | 1 | 3 | 2 | 0 | 1
2012-01-14 00:00:00
[NAME] | 13 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 3 | 0 | 2 | 2 | 1 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 52 | 0 | 0 | 0 | 0 | 2 | 5 | 3 | 1 | 3 | 6 | 5 | 2 | 6 | 2 | 2 | 1 | 4 | 2 | 3 | 3 | 0 | 1 | 0 | 1
Tech | 29 | 1 | 0 | 0 | 0 | 0 | 2 | 1 | 2 | 2 | 6 | 2 | 3 | 1 | 1 | 2 | 1 | 1 | 2 | 0 | 0 | 1 | 1 | 0 | 0
2012-01-15 00:00:00
[NAME] | 13 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 1 | 2 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 1 | 0
[NAME] | 36 | 0 | 0 | 2 | 0 | 0 | 3 | 1 | 2 | 1 | 1 | 1 | 0 | 8 | 0 | 2 | 4 | 3 | 2 | 2 | 1 | 1 | 2 | 0 | 0
Tech | 29 | 0 | 0 | 0 | 0 | 1 | 0 | 2 | 1 | 1 | 2 | 2 | 4 | 0 | 1 | 3 | 2 | 3 | 0 | 1 | 0 | 0 | 0 | 3 | 3
2012-01-16 00:00:00
[NAME] | 98 | 0 | 0 | 0 | 0 | 1 | 5 | 12 | 15 | 13 | 12 | 3 | 7 | 6 | 7 | 7 | 6 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 0
[NAME] | 87 | 0 | 1 | 0 | 1 | 2 | 2 | 2 | 5 | 7 | 7 | 9 | 4 | 9 | 8 | 4 | 15 | 2 | 2 | 1 | 1 | 3 | 1 | 1 | 0
Tech | 193 | 0 | 1 | 0 | 0 | 0 | 2 | 12 | 18 | 21 | 22 | 15 | 14 | 14 | 15 | 16 | 18 | 16 | 3 | 2 | 1 | 2 | 1 | 0 | 0
2012-01-17 00:00:00
[NAME] | 132 | 0 | 0 | 0 | 1 | 0 | 3 | 7 | 17 | 39 | 7 | 10 | 11 | 3 | 10 | 7 | 9 | 3 | 1 | 0 | 0 | 0 | 4 | 0 | 0
[NAME] | 100 | 1 | 1 | 1 | 1 | 2 | 4 | 2 | 11 | 12 | 2 | 6 | 6 | 10 | 11 | 5 | 6 | 4 | 9 | 1 | 3 | 2 | 0 | 0 | 0
Tech | 200 | 0 | 0 | 1 | 2 | 0 | 4 | 9 | 14 | 19 | 12 | 19 | 7 | 19 | 24 | 25 | 19 | 9 | 8 | 2 | 4 | 1 | 0 | 2 | 0
2012-01-18 00:00:00
[NAME] | 71 | 0 | 0 | 0 | 0 | 0 | 6 | 8 | 8 | 3 | 6 | 11 | 6 | 6 | 5 | 2 | 4 | 0 | 2 | 1 | 2 | 1 | 0 | 0 | 0
[NAME] | 101 | 0 | 0 | 0 | 2 | 5 | 5 | 3 | 19 | 4 | 10 | 6 | 9 | 9 | 8 | 6 | 3 | 2 | 3 | 2 | 1 | 0 | 2 | 1 | 1
Tech | 202 | 1 | 0 | 0 | 0 | 0 | 2 | 12 | 14 | 15 | 15 | 19 | 16 | 23 | 14 | 25 | 10 | 18 | 4 | 3 | 5 | 4 | 2 | 0 | 0
2012-01-19 00:00:00
[NAME] | 71 | 0 | 0 | 0 | 0 | 0 | 4 | 7 | 6 | 12 | 9 | 9 | 7 | 2 | 3 | 5 | 2 | 0 | 1 | 1 | 2 | 1 | 0 | 0 | 0
[NAME] | 75 | 0 | 0 | 0 | 1 | 1 | 6 | 9 | 3 | 4 | 5 | 4 | 2 | 11 | 5 | 2 | 4 | 4 | 2 | 4 | 4 | 3 | 0 | 1 | 0
Tech | 189 | 1 | 1 | 0 | 0 | 1 | 1 | 14 | 14 | 15 | 19 | 13 | 10 | 14 | 20 | 18 | 25 | 5 | 7 | 7 | 1 | 2 | 0 | 1 | 0
2012-01-20 00:00:00
[NAME] | 73 | 0 | 1 | 0 | 0 | 0 | 3 | 4 | 12 | 11 | 10 | 2 | 3 | 7 | 6 | 7 | 5 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
[NAME] | 96 | 0 | 1 | 1 | 2 | 0 | 3 | 5 | 6 | 7 | 9 | 11 | 10 | 4 | 14 | 6 | 7 | 2 | 1 | 2 | 3 | 1 | 1 | 0 | 0
Tech | 205 | 0 | 1 | 0 | 0 | 1 | 2 | 11 | 22 | 13 | 23 | 22 | 15 | 15 | 17 | 20 | 23 | 8 | 2 | 2 | 2 | 3 | 1 | 2 | 0
2012-01-21 00:00:00
[NAME] | 23 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 6 | 4 | 3 | 3 | 0 | 1 | 1 | 2 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 35 | 0 | 1 | 0 | 1 | 2 | 2 | 7 | 2 | 2 | 6 | 2 | 2 | 1 | 0 | 3 | 2 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0
Tech | 26 | 0 | 0 | 0 | 0 | 2 | 0 | 1 | 2 | 3 | 1 | 4 | 3 | 2 | 0 | 2 | 3 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0
2012-01-22 00:00:00
[NAME] | 13 | 0 | 0 | 0 | 0 | 3 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 3 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 55 | 1 | 0 | 0 | 3 | 8 | 6 | 9 | 2 | 5 | 3 | 6 | 1 | 3 | 0 | 2 | 0 | 1 | 0 | 0 | 3 | 2 | 0 | 0 | 0
Tech | 31 | 0 | 0 | 0 | 0 | 2 | 2 | 0 | 1 | 2 | 0 | 2 | 2 | 1 | 1 | 1 | 2 | 6 | 3 | 0 | 2 | 3 | 0 | 1 | 0
2012-01-23 00:00:00
[NAME] | 142 | 0 | 0 | 0 | 0 | 0 | 3 | 12 | 9 | 14 | 12 | 51 | 11 | 9 | 10 | 7 | 2 | 3 | 1 | 1 | 1 | 3 | 0 | 0 | 0
[NAME] | 96 | 1 | 0 | 1 | 1 | 1 | 3 | 3 | 6 | 6 | 9 | 13 | 10 | 10 | 10 | 8 | 5 | 2 | 3 | 2 | 1 | 1 | 0 | 0 | 0
Tech | 186 | 0 | 0 | 0 | 0 | 0 | 1 | 10 | 17 | 16 | 15 | 19 | 15 | 11 | 21 | 13 | 13 | 24 | 5 | 4 | 2 | 0 | 0 | 0 | 0
2012-01-24 00:00:00
[NAME] | 77 | 0 | 0 | 1 | 0 | 0 | 1 | 9 | 9 | 14 | 12 | 6 | 4 | 4 | 4 | 4 | 3 | 4 | 1 | 0 | 0 | 0 | 1 | 0 | 0
[NAME] | 96 | 0 | 2 | 1 | 0 | 3 | 5 | 5 | 5 | 5 | 9 | 6 | 11 | 6 | 6 | 7 | 7 | 6 | 4 | 2 | 2 | 1 | 0 | 1 | 2
Tech | 183 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 10 | 20 | 25 | 17 | 14 | 8 | 21 | 29 | 11 | 3 | 9 | 3 | 3 | 2 | 1 | 2 | 1
2012-01-25 00:00:00
[NAME] | 75 | 0 | 0 | 1 | 1 | 1 | 0 | 8 | 4 | 11 | 8 | 8 | 8 | 7 | 7 | 3 | 3 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 2
[NAME] | 103 | 0 | 0 | 0 | 1 | 6 | 1 | 10 | 5 | 10 | 8 | 10 | 7 | 8 | 7 | 11 | 10 | 5 | 2 | 0 | 0 | 0 | 1 | 1 | 0
Tech | 182 | 0 | 0 | 0 | 0 | 4 | 1 | 4 | 23 | 15 | 19 | 10 | 10 | 10 | 21 | 26 | 18 | 7 | 6 | 4 | 2 | 1 | 1 | 0 | 0
2012-01-26 00:00:00
[NAME] | 34 | 1 | 0 | 0 | 0 | 1 | 0 | 3 | 7 | 4 | 4 | 1 | 2 | 3 | 2 | 4 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
[NAME] | 64 | 0 | 0 | 0 | 1 | 4 | 5 | 3 | 2 | 5 | 10 | 3 | 8 | 5 | 5 | 4 | 1 | 2 | 1 | 3 | 0 | 1 | 0 | 1 | 0
Tech | 187 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 11 | 14 | 20 | 17 | 14 | 21 | 15 | 22 | 19 | 13 | 4 | 3 | 2 | 2 | 2 | 1 | 0
2012-01-27 00:00:00
[NAME] | 67 | 0 | 0 | 0 | 0 | 0 | 4 | 9 | 8 | 11 | 6 | 7 | 0 | 4 | 3 | 5 | 5 | 3 | 3 | 0 | 1 | 3 | 0 | 0 | 0
[NAME] | 86 | 0 | 3 | 2 | 2 | 2 | 3 | 4 | 3 | 7 | 8 | 7 | 4 | 12 | 7 | 7 | 8 | 4 | 1 | 1 | 1 | 0 | 0 | 0 | 0
Tech | 197 | 0 | 1 | 0 | 1 | 0 | 4 | 9 | 9 | 15 | 25 | 20 | 14 | 18 | 23 | 18 | 13 | 11 | 4 | 1 | 5 | 1 | 5 | 0 | 0
2012-01-28 00:00:00
[NAME] | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 1 | 0 | 0 | 2 | 4 | 1 | 0 | 3 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 40 | 1 | 0 | 0 | 0 | 1 | 2 | 2 | 3 | 4 | 3 | 0 | 3 | 1 | 3 | 0 | 0 | 2 | 2 | 1 | 2 | 6 | 2 | 1 | 1
Tech | 30 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 3 | 1 | 4 | 4 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 0 | 1 | 0 | 1 | 0 | 1
2012-01-29 00:00:00
[NAME] | 21 | 0 | 0 | 0 | 0 | 0 | 3 | 1 | 0 | 2 | 1 | 3 | 3 | 2 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0
[NAME] | 49 | 0 | 0 | 0 | 0 | 2 | 3 | 6 | 6 | 4 | 2 | 5 | 2 | 5 | 0 | 0 | 4 | 3 | 3 | 1 | 0 | 0 | 1 | 2 | 0
Tech | 33 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 3 | 2 | 5 | 4 | 3 | 2 | 4 | 0 | 2 | 1 | 0 | 1 | 1 | 1 | 0 | 0
2012-01-30 00:00:00
[NAME] | 98 | 0 | 0 | 0 | 0 | 0 | 2 | 9 | 20 | 12 | 11 | 8 | 8 | 4 | 6 | 4 | 5 | 3 | 0 | 0 | 2 | 1 | 1 | 1 | 1
[NAME] | 99 | 0 | 0 | 0 | 1 | 5 | 4 | 6 | 12 | 13 | 10 | 7 | 6 | 4 | 5 | 7 | 5 | 9 | 0 | 1 | 1 | 2 | 1 | 0 | 0
Tech | 233 | 2 | 1 | 0 | 0 | 0 | 3 | 12 | 22 | 27 | 22 | 25 | 17 | 14 | 20 | 28 | 16 | 10 | 4 | 4 | 4 | 1 | 1 | 0 | 0
2012-01-31 00:00:00
[NAME] | 68 | 0 | 0 | 0 | 0 | 0 | 4 | 4 | 5 | 11 | 9 | 6 | 6 | 3 | 12 | 2 | 3 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 61 | 0 | 0 | 0 | 0 | 2 | 0 | 5 | 8 | 5 | 4 | 5 | 5 | 4 | 4 | 8 | 4 | 1 | 3 | 0 | 1 | 1 | 0 | 1 | 0
Tech | 193 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 18 | 24 | 24 | 14 | 22 | 12 | 20 | 20 | 10 | 7 | 6 | 1 | 4 | 1 | 1 | 0 | 0