Spreadsheet: 78938d1279205661-sumif-book1
Sheet: Sheet2

Set | Data | Date | Time | Function 1 | Function 2 |  |  |  | Data | Date | Time | Function 1 | Function 2
Set 1 | Data 1 | 2010-06-01 00:00:00 | 08:00:00 | 131 | 196.54 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 1900-01-01 00:00:00
Set 1 | Data 1 | 2010-06-01 00:00:00 | 08:30:00 | 288 | 429.73 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 00:30:00
Set 1 | Data 1 | 2010-06-01 00:00:00 | 09:00:00 | 547 | 340.13 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 01:00:00
Set 1 | Data 1 | 2010-06-01 00:00:00 | 09:30:00 | 930 | 379.35 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 01:30:00
Set 1 | Data 1 | 2010-06-01 00:00:00 | 10:00:00 | 1019 | 385.5 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 02:00:00
Set 1 | Data 1 | 2010-06-01 00:00:00 | 10:30:00 | 1161 | 381.86 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 02:30:00
Set 1 | Data 1 | 2010-06-01 00:00:00 | 11:00:00 | 1250 | 378.9 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 03:00:00
Set 1 | Data 1 | 2010-06-01 00:00:00 | 11:30:00 | 1447 | 340.96 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 03:30:00
Set 1 | Data 1 | 2010-06-01 00:00:00 | 12:00:00 | 1383 | 364.65 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 04:00:00
Set 1 | Data 1 | 2010-06-01 00:00:00 | 12:30:00 | 1511 | 342.82 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 04:30:00
Set 1 | Data 1 | 2010-06-01 00:00:00 | 13:00:00 | 1319 | 384.96 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 05:00:00
Set 1 | Data 1 | 2010-06-01 00:00:00 | 13:30:00 | 1390 | 376.29 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 05:30:00
Set 1 | Data 1 | 2010-06-01 00:00:00 | 14:00:00 | 1352 | 403.68 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 06:00:00
Set 1 | Data 1 | 2010-06-01 00:00:00 | 14:30:00 | 1398 | 408.79 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 06:30:00
Set 1 | Data 1 | 2010-06-01 00:00:00 | 15:00:00 | 1536 | 381.83 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 07:00:00
Set 1 | Data 1 | 2010-06-01 00:00:00 | 15:30:00 | 1356 | 412.72 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 07:30:00
Set 1 | Data 1 | 2010-06-01 00:00:00 | 16:00:00 | 1389 | 408.33 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 08:00:00
Set 1 | Data 1 | 2010-06-01 00:00:00 | 16:30:00 | 1358 | 398.03 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 08:30:00
Set 1 | Data 1 | 2010-06-01 00:00:00 | 17:00:00 | 1153 | 419.4 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 09:00:00
Set 1 | Data 1 | 2010-06-01 00:00:00 | 17:30:00 | 1181 | 408.35 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 09:30:00
Set 1 | Data 1 | 2010-06-01 00:00:00 | 18:00:00 | 1088 | 441.65 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 10:00:00
Set 1 | Data 1 | 2010-06-01 00:00:00 | 18:30:00 | 869 | 421.12 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 10:30:00
Set 1 | Data 1 | 2010-06-01 00:00:00 | 19:00:00 | 725 | 396.63 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 11:00:00
Set 1 | Data 1 | 2010-06-01 00:00:00 | 19:30:00 | 573 | 394.09 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 11:30:00
Set 1 | Data 1 | 2010-06-01 00:00:00 | 20:00:00 | 537 | 390.13 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 12:00:00
Set 1 | Data 1 | 2010-06-01 00:00:00 | 20:30:00 | 443 | 403.07 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 12:30:00
Set 1 | Data 1 | 2010-06-01 00:00:00 | 21:00:00 | 359 | 453.71 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 13:00:00
Set 1 | Data 1 | 2010-06-01 00:00:00 | 21:30:00 | 298 | 418.22 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 13:30:00
Set 1 | Data 1 | 2010-06-01 00:00:00 | 22:00:00 | 248 | 478.27 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 14:00:00
Set 1 | Data 1 | 2010-06-01 00:00:00 | 22:30:00 | 201 | 462.79 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 14:30:00
Set 1 | Data 1 | 2010-06-01 00:00:00 | 23:00:00 | 65 | 443.47 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 15:00:00
Set 2 | Data 1 | 2010-06-01 00:00:00 | 1900-01-01 00:00:00 | 65 | 108.65 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 15:30:00
Set 2 | Data 1 | 2010-06-01 00:00:00 | 00:30:00 | 92 | 281.46 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 16:00:00
Set 2 | Data 1 | 2010-06-01 00:00:00 | 01:00:00 | 51 | 869.43 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 16:30:00
Set 2 | Data 1 | 2010-06-01 00:00:00 | 01:30:00 | 11 | 158.91 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 17:00:00
Set 2 | Data 1 | 2010-06-01 00:00:00 | 02:00:00 | 15 | 506.39 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 17:30:00
Set 2 | Data 1 | 2010-06-01 00:00:00 | 02:30:00 | 15 | 590.2 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 18:00:00
Set 2 | Data 1 | 2010-06-01 00:00:00 | 03:00:00 | 5 | 494.17 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 18:30:00
Set 2 | Data 1 | 2010-06-01 00:00:00 | 03:30:00 | 6 | 429.75 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 19:00:00
Set 2 | Data 1 | 2010-06-01 00:00:00 | 04:00:00 | 1 | 380 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 19:30:00
Set 2 | Data 1 | 2010-06-01 00:00:00 | 05:00:00 | 9 | 335.17 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 20:00:00
Set 2 | Data 1 | 2010-06-01 00:00:00 | 05:30:00 | 13 | 357.03 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 20:30:00
Set 2 | Data 1 | 2010-06-01 00:00:00 | 06:00:00 | 26 | 257.92 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 21:00:00
Set 2 | Data 1 | 2010-06-01 00:00:00 | 06:30:00 | 52 | 305.08 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 21:30:00
Set 2 | Data 1 | 2010-06-01 00:00:00 | 07:00:00 | 98 | 259.89 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 22:00:00
Set 2 | Data 1 | 2010-06-01 00:00:00 | 07:30:00 | 201 | 292.41 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 22:30:00
Set 2 | Data 1 | 2010-06-01 00:00:00 | 08:00:00 | 315 | 279.53 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 23:00:00
Set 2 | Data 1 | 2010-06-01 00:00:00 | 08:30:00 | 475 | 364.57 |  |  |  | Data 1 | 2010-06-01 00:00:00 | 23:30:00
Set 2 | Data 1 | 2010-06-01 00:00:00 | 09:00:00 | 669 | 377.4
Set 2 | Data 1 | 2010-06-01 00:00:00 | 09:30:00 | 800 | 397.76
Set 2 | Data 1 | 2010-06-01 00:00:00 | 10:00:00 | 957 | 390.29
Set 2 | Data 1 | 2010-06-01 00:00:00 | 10:30:00 | 1024 | 361.93
Set 2 | Data 1 | 2010-06-01 00:00:00 | 11:00:00 | 982 | 385.21
Set 2 | Data 1 | 2010-06-01 00:00:00 | 11:30:00 | 1008 | 378.21
Set 2 | Data 1 | 2010-06-01 00:00:00 | 12:00:00 | 985 | 396.74
Set 2 | Data 1 | 2010-06-01 00:00:00 | 12:30:00 | 1016 | 382.48
Set 2 | Data 1 | 2010-06-01 00:00:00 | 13:00:00 | 983 | 398.68
Set 2 | Data 1 | 2010-06-01 00:00:00 | 13:30:00 | 954 | 400.38
Set 2 | Data 1 | 2010-06-01 00:00:00 | 14:00:00 | 902 | 373.49
Set 2 | Data 1 | 2010-06-01 00:00:00 | 14:30:00 | 857 | 414.63
Set 2 | Data 1 | 2010-06-01 00:00:00 | 15:00:00 | 786 | 438.63
Set 2 | Data 1 | 2010-06-01 00:00:00 | 15:30:00 | 716 | 416.85
Set 2 | Data 1 | 2010-06-01 00:00:00 | 16:00:00 | 578 | 453.99
Set 2 | Data 1 | 2010-06-01 00:00:00 | 16:30:00 | 644 | 402.59
Set 2 | Data 1 | 2010-06-01 00:00:00 | 17:00:00 | 763 | 411.29
Set 2 | Data 1 | 2010-06-01 00:00:00 | 17:30:00 | 702 | 395.75
Set 2 | Data 1 | 2010-06-01 00:00:00 | 18:00:00 | 551 | 451.68
Set 2 | Data 1 | 2010-06-01 00:00:00 | 18:30:00 | 541 | 478.92
Set 2 | Data 1 | 2010-06-01 00:00:00 | 19:00:00 | 587 | 414.88
Set 2 | Data 1 | 2010-06-01 00:00:00 | 19:30:00 | 635 | 368.97
Set 2 | Data 1 | 2010-06-01 00:00:00 | 20:00:00 | 505 | 424.28
Set 2 | Data 1 | 2010-06-01 00:00:00 | 20:30:00 | 471 | 416.44
Set 2 | Data 1 | 2010-06-01 00:00:00 | 21:00:00 | 428 | 417.08
Set 2 | Data 1 | 2010-06-01 00:00:00 | 21:30:00 | 338 | 433
Set 2 | Data 1 | 2010-06-01 00:00:00 | 22:00:00 | 242 | 461.83
Set 2 | Data 1 | 2010-06-01 00:00:00 | 22:30:00 | 199 | 398.39
Set 2 | Data 1 | 2010-06-01 00:00:00 | 23:00:00 | 246 | 406.08
Set 2 | Data 1 | 2010-06-01 00:00:00 | 23:30:00 | 201 | 464.56
Set 3 | Data 1 | 2010-06-01 00:00:00 | 08:00:00 | 51 | 96.73
Set 3 | Data 1 | 2010-06-01 00:00:00 | 08:30:00 | 122 | 353.69
Set 3 | Data 1 | 2010-06-01 00:00:00 | 09:00:00 | 198 | 378.57
Set 3 | Data 1 | 2010-06-01 00:00:00 | 09:30:00 | 328 | 370.58
Set 3 | Data 1 | 2010-06-01 00:00:00 | 10:00:00 | 446 | 373.01
Set 3 | Data 1 | 2010-06-01 00:00:00 | 10:30:00 | 534 | 344.66
Set 3 | Data 1 | 2010-06-01 00:00:00 | 11:00:00 | 483 | 412.04
Set 3 | Data 1 | 2010-06-01 00:00:00 | 11:30:00 | 486 | 365.7
Set 3 | Data 1 | 2010-06-01 00:00:00 | 12:00:00 | 509 | 371.76
Set 3 | Data 1 | 2010-06-01 00:00:00 | 12:30:00 | 432 | 389.24
Set 3 | Data 1 | 2010-06-01 00:00:00 | 13:00:00 | 432 | 382.73
Set 3 | Data 1 | 2010-06-01 00:00:00 | 13:30:00 | 401 | 419.01
Set 3 | Data 1 | 2010-06-01 00:00:00 | 14:00:00 | 392 | 391.27
Set 3 | Data 1 | 2010-06-01 00:00:00 | 14:30:00 | 360 | 410.32
Set 3 | Data 1 | 2010-06-01 00:00:00 | 15:00:00 | 368 | 389.03
Set 3 | Data 1 | 2010-06-01 00:00:00 | 15:30:00 | 510 | 316.54
Set 3 | Data 1 | 2010-06-01 00:00:00 | 16:00:00 | 539 | 340.04
Set 3 | Data 1 | 2010-06-01 00:00:00 | 16:30:00 | 404 | 371.54
Set 3 | Data 1 | 2010-06-01 00:00:00 | 17:00:00 | 306 | 358.62
Set 3 | Data 1 | 2010-06-01 00:00:00 | 17:30:00 | 307 | 374.74
Set 3 | Data 1 | 2010-06-01 00:00:00 | 18:00:00 | 317 | 365.41
Set 3 | Data 1 | 2010-06-01 00:00:00 | 18:30:00 | 310 | 415.98
Set 3 | Data 1 | 2010-06-01 00:00:00 | 19:00:00 | 346 | 331.9
Set 3 | Data 1 | 2010-06-01 00:00:00 | 19:30:00 | 302 | 371.25
Set 3 | Data 1 | 2010-06-01 00:00:00 | 20:00:00 | 298 | 337.65
Set 3 | Data 1 | 2010-06-01 00:00:00 | 20:30:00 | 381 | 301.33
Set 3 | Data 1 | 2010-06-01 00:00:00 | 21:00:00 | 301 | 352.26
Set 3 | Data 1 | 2010-06-01 00:00:00 | 21:30:00 | 182 | 413.73
Set 3 | Data 1 | 2010-06-01 00:00:00 | 22:00:00 | 106 | 442.05
Set 3 | Data 1 | 2010-06-01 00:00:00 | 22:30:00 | 40 | 613.8
Set 3 | Data 1 | 2010-06-01 00:00:00 | 23:00:00 | 29 | 686.64