Spreadsheet: 125834d1319237552-sumif-function-sumif-problem
Sheet: Sheet1

Time Stamp | Name | Number
2011-10-20 00:00:00 | A | 938 |  | 2011-10-20 00:00:00 | 14388.3
2011-10-20 00:00:00 | B | 1457.1 |  | 2011-10-20 01:00:00 | 13780.9
2011-10-20 00:00:00 | C | 518.6 |  | 2011-10-20 02:00:00 | 13464.6
2011-10-20 00:00:00 | D | 923.8 |  | 2011-10-20 03:00:00 | 13303.1
2011-10-20 00:00:00 | E | 852.5 |  | 2011-10-20 04:00:00 | 13478.3
2011-10-20 00:00:00 | F | 1898.2 |  | 2011-10-20 05:00:00 | 14429.9
2011-10-20 00:00:00 | H | 628.7 |  | 2011-10-20 06:00:00 | 16535
2011-10-20 00:00:00 | I | 216.5 |  | 2011-10-20 07:00:00 | 0
2011-10-20 00:00:00 | J | 4768.3 |  | 2011-10-20 08:00:00 | 18870.9
2011-10-20 00:00:00 | K | 682.8 |  | 2011-10-20 09:00:00 | 19207
2011-10-20 00:00:00 | L | 1503.8 |  | 2011-10-20 10:00:00 | 0
2011-10-20 01:00:00 | A | 900.3 |  | 2011-10-20 11:00:00 | 19391.6
2011-10-20 01:00:00 | B | 1412.4 |  | 2011-10-20 12:00:00 | 19245.9
2011-10-20 01:00:00 | C | 490.2 |  | 2011-10-20 13:00:00 | 0
2011-10-20 01:00:00 | D | 887.3 |  | 2011-10-20 14:00:00 | 19062.3
2011-10-20 01:00:00 | E | 815.6 |  | 2011-10-20 15:00:00 | 18903.7
2011-10-20 01:00:00 | F | 1813.7 |  | 2011-10-20 16:00:00 | 0
2011-10-20 01:00:00 | H | 580.6 |  | 2011-10-20 17:00:00 | 19184.9
2011-10-20 01:00:00 | I | 204.3 |  | 2011-10-20 18:00:00 | 19859.4
2011-10-20 01:00:00 | J | 4543.2 |  | 2011-10-20 19:00:00 | 0
2011-10-20 01:00:00 | K | 675.8 |  | 2011-10-20 20:00:00 | 19132
2011-10-20 01:00:00 | L | 1457.5 |  | 2011-10-20 21:00:00 | 0
2011-10-20 02:00:00 | A | 879.7 |  | 2011-10-20 22:00:00 | 0
2011-10-20 02:00:00 | B | 1391.4 |  | 2011-10-20 23:00:00 | 15148.1
2011-10-20 02:00:00 | C | 472.5
2011-10-20 02:00:00 | D | 867.7
2011-10-20 02:00:00 | E | 788.6
2011-10-20 02:00:00 | F | 1763.8
2011-10-20 02:00:00 | H | 569.5
2011-10-20 02:00:00 | I | 198.7
2011-10-20 02:00:00 | J | 4429.1
2011-10-20 02:00:00 | K | 670.5
2011-10-20 02:00:00 | L | 1433.1
2011-10-20 03:00:00 | A | 875.2
2011-10-20 03:00:00 | B | 1354.7
2011-10-20 03:00:00 | C | 465.2
2011-10-20 03:00:00 | D | 863
2011-10-20 03:00:00 | E | 791.2
2011-10-20 03:00:00 | F | 1740.9
2011-10-20 03:00:00 | H | 558.4
2011-10-20 03:00:00 | I | 194.8
2011-10-20 03:00:00 | J | 4371.9
2011-10-20 03:00:00 | K | 667.1
2011-10-20 03:00:00 | L | 1420.7
2011-10-20 04:00:00 | A | 892.2
2011-10-20 04:00:00 | B | 1387
2011-10-20 04:00:00 | C | 475.4
2011-10-20 04:00:00 | D | 877
2011-10-20 04:00:00 | E | 798.7
2011-10-20 04:00:00 | F | 1762.6
2011-10-20 04:00:00 | H | 582.2
2011-10-20 04:00:00 | I | 196.6
2011-10-20 04:00:00 | J | 4398.5
2011-10-20 04:00:00 | K | 671.3
2011-10-20 04:00:00 | L | 1436.8
2011-10-20 05:00:00 | A | 963.6
2011-10-20 05:00:00 | B | 1509.7
2011-10-20 05:00:00 | C | 510.9
2011-10-20 05:00:00 | D | 947.4
2011-10-20 05:00:00 | E | 858.1
2011-10-20 05:00:00 | F | 1882.8
2011-10-20 05:00:00 | H | 649.9
2011-10-20 05:00:00 | I | 216.6
2011-10-20 05:00:00 | J | 4684.3
2011-10-20 05:00:00 | K | 683.4
2011-10-20 05:00:00 | L | 1523.2
2011-10-20 06:00:00 | A | 1139.9
2011-10-20 06:00:00 | B | 1736.5
2011-10-20 06:00:00 | C | 594.7
2011-10-20 06:00:00 | D | 1084.6
2011-10-20 06:00:00 | E | 979.6
2011-10-20 06:00:00 | F | 2168.7
2011-10-20 06:00:00 | H | 785.4
2011-10-20 06:00:00 | I | 262.5
2011-10-20 06:00:00 | J | 5355.2
2011-10-20 06:00:00 | K | 717.2
2011-10-20 06:00:00 | L | 1710.7
2011-10-20 07:00:00 | A | 1258.9
2011-10-20 07:00:00 | B | 1874
2011-10-20 07:00:00 | C | 682.9
2011-10-20 07:00:00 | D | 1174.1
2011-10-20 07:00:00 | E | 1075.4
2011-10-20 07:00:00 | F | 2384.4
2011-10-20 07:00:00 | H | 875.6
2011-10-20 07:00:00 | I | 293.9
2011-10-20 07:00:00 | J | 6010.6
2011-10-20 07:00:00 | K | 733.7
2011-10-20 07:00:00 | L | 1840.2
2011-10-20 08:00:00 | A | 1286.5
2011-10-20 08:00:00 | B | 1875.5
2011-10-20 08:00:00 | C | 711.1
2011-10-20 08:00:00 | D | 1189.8
2011-10-20 08:00:00 | E | 1105.5
2011-10-20 08:00:00 | F | 2484.5
2011-10-20 08:00:00 | H | 911.4
2011-10-20 08:00:00 | I | 298.4
2011-10-20 08:00:00 | J | 6407.9
2011-10-20 08:00:00 | K | 732.7
2011-10-20 08:00:00 | L | 1867.6
2011-10-20 09:00:00 | A | 1287.3
2011-10-20 09:00:00 | B | 1900.7
2011-10-20 09:00:00 | C | 737.6
2011-10-20 09:00:00 | D | 1215.3
2011-10-20 09:00:00 | E | 1114.8
2011-10-20 09:00:00 | F | 2545.1
2011-10-20 09:00:00 | H | 915.7
2011-10-20 09:00:00 | I | 295.2
2011-10-20 09:00:00 | J | 6573.9
2011-10-20 09:00:00 | K | 732.2
2011-10-20 09:00:00 | L | 1889.2
2011-10-20 10:00:00 | A | 1297.9
2011-10-20 10:00:00 | B | 1915.6
2011-10-20 10:00:00 | C | 742.4
2011-10-20 10:00:00 | D | 1238.2
2011-10-20 10:00:00 | E | 1134.3
2011-10-20 10:00:00 | F | 2573.9
2011-10-20 10:00:00 | H | 918.6
2011-10-20 10:00:00 | I | 294
2011-10-20 10:00:00 | J | 6633.7
2011-10-20 10:00:00 | K | 733.5
2011-10-20 10:00:00 | L | 1913.7
2011-10-20 11:00:00 | A | 1301.2
2011-10-20 11:00:00 | B | 1918.2
2011-10-20 11:00:00 | C | 735.5
2011-10-20 11:00:00 | D | 1242.9
2011-10-20 11:00:00 | E | 1132.5
2011-10-20 11:00:00 | F | 2583.1
2011-10-20 11:00:00 | H | 914.3
2011-10-20 11:00:00 | I | 289.9
2011-10-20 11:00:00 | J | 6623.9
2011-10-20 11:00:00 | K | 731.7
2011-10-20 11:00:00 | L | 1918.4
2011-10-20 12:00:00 | A | 1294.2
2011-10-20 12:00:00 | B | 1898.2
2011-10-20 12:00:00 | C | 724.7
2011-10-20 12:00:00 | D | 1225.7
2011-10-20 12:00:00 | E | 1115.3
2011-10-20 12:00:00 | F | 2568.7
2011-10-20 12:00:00 | H | 885.8
2011-10-20 12:00:00 | I | 288.9
2011-10-20 12:00:00 | J | 6609.7
2011-10-20 12:00:00 | K | 729.7
2011-10-20 12:00:00 | L | 1905
2011-10-20 13:00:00 | A | 1285.8
2011-10-20 13:00:00 | B | 1897.1
2011-10-20 13:00:00 | C | 725.6
2011-10-20 13:00:00 | D | 1229.7
2011-10-20 13:00:00 | E | 1112.8
2011-10-20 13:00:00 | F | 2558.3
2011-10-20 13:00:00 | H | 901.3
2011-10-20 13:00:00 | I | 284.8
2011-10-20 13:00:00 | J | 6618.7
2011-10-20 13:00:00 | K | 722.2
2011-10-20 13:00:00 | L | 1914.7
2011-10-20 14:00:00 | A | 1273.2
2011-10-20 14:00:00 | B | 1854.6
2011-10-20 14:00:00 | C | 718.9
2011-10-20 14:00:00 | D | 1220.7
2011-10-20 14:00:00 | E | 1101.9
2011-10-20 14:00:00 | F | 2550
2011-10-20 14:00:00 | H | 872.5
2011-10-20 14:00:00 | I | 287.4
2011-10-20 14:00:00 | J | 6578.8
2011-10-20 14:00:00 | K | 722.4
2011-10-20 14:00:00 | L | 1881.9
2011-10-20 15:00:00 | A | 1266.4
2011-10-20 15:00:00 | B | 1822.6
2011-10-20 15:00:00 | C | 716.1
2011-10-20 15:00:00 | D | 1198.2
2011-10-20 15:00:00 | E | 1089.6
2011-10-20 15:00:00 | F | 2540.2
2011-10-20 15:00:00 | H | 853.1
2011-10-20 15:00:00 | I | 285.8
2011-10-20 15:00:00 | J | 6560.5
2011-10-20 15:00:00 | K | 726.5
2011-10-20 15:00:00 | L | 1844.7
2011-10-20 16:00:00 | A | 1267.9
2011-10-20 16:00:00 | B | 1843.8
2011-10-20 16:00:00 | C | 718.2
2011-10-20 16:00:00 | D | 1201.1
2011-10-20 16:00:00 | E | 1101.1
2011-10-20 16:00:00 | F | 2544.2
2011-10-20 16:00:00 | H | 852.4
2011-10-20 16:00:00 | I | 284.2
2011-10-20 16:00:00 | J | 6553.4
2011-10-20 16:00:00 | K | 728.7
2011-10-20 16:00:00 | L | 1844.8
2011-10-20 17:00:00 | A | 1300.9
2011-10-20 17:00:00 | B | 1888.3
2011-10-20 17:00:00 | C | 731.6
2011-10-20 17:00:00 | D | 1222
2011-10-20 17:00:00 | E | 1143
2011-10-20 17:00:00 | F | 2589.5
2011-10-20 17:00:00 | H | 894
2011-10-20 17:00:00 | I | 289.6
2011-10-20 17:00:00 | J | 6529.6
2011-10-20 17:00:00 | K | 727.7
2011-10-20 17:00:00 | L | 1868.7
2011-10-20 18:00:00 | A | 1390.4
2011-10-20 18:00:00 | B | 1991
2011-10-20 18:00:00 | C | 770.1
2011-10-20 18:00:00 | D | 1275.8
2011-10-20 18:00:00 | E | 1216.5
2011-10-20 18:00:00 | F | 2787.8
2011-10-20 18:00:00 | H | 948
2011-10-20 18:00:00 | I | 327.3
2011-10-20 18:00:00 | J | 6467.6
2011-10-20 18:00:00 | K | 745.2
2011-10-20 18:00:00 | L | 1939.7
2011-10-20 19:00:00 | A | 1376.2
2011-10-20 19:00:00 | B | 2033
2011-10-20 19:00:00 | C | 765.8
2011-10-20 19:00:00 | D | 1292
2011-10-20 19:00:00 | E | 1213.8
2011-10-20 19:00:00 | F | 2798.6
2011-10-20 19:00:00 | H | 931.5
2011-10-20 19:00:00 | I | 334.6
2011-10-20 19:00:00 | J | 6331.5
2011-10-20 19:00:00 | K | 747.4
2011-10-20 19:00:00 | L | 1970
2011-10-20 20:00:00 | A | 1307.4
2011-10-20 20:00:00 | B | 1969.3
2011-10-20 20:00:00 | C | 734.6
2011-10-20 20:00:00 | D | 1255
2011-10-20 20:00:00 | E | 1173.2
2011-10-20 20:00:00 | F | 2707.8
2011-10-20 20:00:00 | H | 882
2011-10-20 20:00:00 | I | 318.6
2011-10-20 20:00:00 | J | 6108.3
2011-10-20 20:00:00 | K | 735.3
2011-10-20 20:00:00 | L | 1940.5
2011-10-20 21:00:00 | A | 1219.9
2011-10-20 21:00:00 | B | 1828.3
2011-10-20 21:00:00 | C | 690.3
2011-10-20 21:00:00 | D | 1173.3
2011-10-20 21:00:00 | E | 1097.3
2011-10-20 21:00:00 | F | 2542.4
2011-10-20 21:00:00 | H | 799.4
2011-10-20 21:00:00 | I | 295.2
2011-10-20 21:00:00 | J | 5835.6
2011-10-20 21:00:00 | K | 719.4
2011-10-20 21:00:00 | L | 1861.1
2011-10-20 22:00:00 | A | 1086.5
2011-10-20 22:00:00 | B | 1658.4
2011-10-20 22:00:00 | C | 629.8
2011-10-20 22:00:00 | D | 1069.6
2011-10-20 22:00:00 | E | 993.9
2011-10-20 22:00:00 | F | 2270.1
2011-10-20 22:00:00 | H | 704.1
2011-10-20 22:00:00 | I | 259.8
2011-10-20 22:00:00 | J | 5469.5
2011-10-20 22:00:00 | K | 702.6
2011-10-20 22:00:00 | L | 1737.8
2011-10-20 23:00:00 | A | 988.6
2011-10-20 23:00:00 | B | 1514.7
2011-10-20 23:00:00 | C | 561
2011-10-20 23:00:00 | D | 986.4
2011-10-20 23:00:00 | E | 905
2011-10-20 23:00:00 | F | 2020.1
2011-10-20 23:00:00 | H | 624.7
2011-10-20 23:00:00 | I | 226.8
2011-10-20 23:00:00 | J | 5006.2
2011-10-20 23:00:00 | K | 688.4
2011-10-20 23:00:00 | L | 1626.2