Spreadsheet: 57902d1258121867-summing-numbers-based-on-date-trial
Sheet: Sheet1

 |  | Input |  |  |  |  |  | Result
Month | date | User1 | User2 | User3 |  |  | Month |  | User1 | User2 | User3
1 | 2009-01-01 00:00:00 | 93 | 98 | 92 |  |  | January | 1 | 608 | 641 | 602
1 | 2009-01-06 00:00:00 | 85 | 83 | 81 |  |  | February | 2 | 450 | 455 | 476
1 | 2009-01-11 00:00:00 | 84 | 97 | 93 |  |  | March | 3 | 534 | 546 | 577
1 | 2009-01-16 00:00:00 | 93 | 92 | 83 |  |  | April | 4 | 538 | 552 | 540
1 | 2009-01-21 00:00:00 | 81 | 100 | 88 |  |  | May | 5 | 607 | 629 | 621
1 | 2009-01-26 00:00:00 | 86 | 88 | 82 |  |  | June | 6 | 554 | 536 | 547
1 | 2009-01-31 00:00:00 | 86 | 83 | 83 |  |  | July | 7 | 513 | 537 | 544
2 | 2009-02-05 00:00:00 | 89 | 96 | 100 |  |  | August | 8 | 550 | 548 | 519
2 | 2009-02-10 00:00:00 | 88 | 83 | 97 |  |  | September | 9 | 540 | 553 | 541
2 | 2009-02-15 00:00:00 | 90 | 95 | 89 |  |  | October | 10 | 566 | 521 | 565
2 | 2009-02-20 00:00:00 | 90 | 94 | 92 |  |  | November | 11 | 539 | 543 | 528
2 | 2009-02-25 00:00:00 | 93 | 87 | 98 |  |  | December | 12 | 539 | 532 | 567
3 | 2009-03-02 00:00:00 | 88 | 84 | 93 |  |  | Total |  | 6538 | 6593 | 6627
3 | 2009-03-07 00:00:00 | 87 | 91 | 100
3 | 2009-03-12 00:00:00 | 90 | 99 | 98
3 | 2009-03-17 00:00:00 | 88 | 100 | 97
3 | 2009-03-22 00:00:00 | 93 | 89 | 99
3 | 2009-03-27 00:00:00 | 88 | 83 | 90
4 | 2009-04-01 00:00:00 | 90 | 93 | 100
4 | 2009-04-06 00:00:00 | 84 | 83 | 95
4 | 2009-04-11 00:00:00 | 93 | 91 | 87
4 | 2009-04-16 00:00:00 | 83 | 98 | 82
4 | 2009-04-21 00:00:00 | 99 | 93 | 94
4 | 2009-04-26 00:00:00 | 89 | 94 | 82
5 | 2009-05-01 00:00:00 | 83 | 89 | 92
5 | 2009-05-06 00:00:00 | 86 | 99 | 81
5 | 2009-05-11 00:00:00 | 82 | 82 | 96
5 | 2009-05-16 00:00:00 | 91 | 83 | 84
5 | 2009-05-21 00:00:00 | 82 | 84 | 89
5 | 2009-05-26 00:00:00 | 96 | 94 | 83
5 | 2009-05-31 00:00:00 | 87 | 98 | 96
6 | 2009-06-05 00:00:00 | 100 | 93 | 94
6 | 2009-06-10 00:00:00 | 92 | 87 | 84
6 | 2009-06-15 00:00:00 | 88 | 86 | 93
6 | 2009-06-20 00:00:00 | 86 | 94 | 97
6 | 2009-06-25 00:00:00 | 88 | 91 | 98
6 | 2009-06-30 00:00:00 | 100 | 85 | 81
7 | 2009-07-05 00:00:00 | 83 | 98 | 88
7 | 2009-07-10 00:00:00 | 93 | 83 | 92
7 | 2009-07-15 00:00:00 | 90 | 91 | 85
7 | 2009-07-20 00:00:00 | 87 | 85 | 95
7 | 2009-07-25 00:00:00 | 80 | 92 | 99
7 | 2009-07-30 00:00:00 | 80 | 88 | 85
8 | 2009-08-04 00:00:00 | 100 | 98 | 91
8 | 2009-08-09 00:00:00 | 86 | 99 | 81
8 | 2009-08-14 00:00:00 | 87 | 84 | 80
8 | 2009-08-19 00:00:00 | 100 | 83 | 90
8 | 2009-08-24 00:00:00 | 87 | 88 | 84
8 | 2009-08-29 00:00:00 | 90 | 96 | 93
9 | 2009-09-03 00:00:00 | 94 | 93 | 97
9 | 2009-09-08 00:00:00 | 91 | 91 | 86
9 | 2009-09-13 00:00:00 | 86 | 100 | 80
9 | 2009-09-18 00:00:00 | 86 | 83 | 94
9 | 2009-09-23 00:00:00 | 95 | 97 | 95
9 | 2009-09-28 00:00:00 | 88 | 89 | 89
10 | 2009-10-03 00:00:00 | 98 | 81 | 99
10 | 2009-10-08 00:00:00 | 93 | 85 | 92
10 | 2009-10-13 00:00:00 | 86 | 94 | 94
10 | 2009-10-18 00:00:00 | 93 | 92 | 85
10 | 2009-10-23 00:00:00 | 97 | 82 | 97
10 | 2009-10-28 00:00:00 | 99 | 87 | 98
11 | 2009-11-02 00:00:00 | 90 | 82 | 91
11 | 2009-11-07 00:00:00 | 82 | 92 | 83
11 | 2009-11-12 00:00:00 | 86 | 95 | 86
11 | 2009-11-17 00:00:00 | 96 | 91 | 86
11 | 2009-11-22 00:00:00 | 97 | 98 | 99
11 | 2009-11-27 00:00:00 | 88 | 85 | 83
12 | 2009-12-02 00:00:00 | 98 | 88 | 86
12 | 2009-12-07 00:00:00 | 84 | 81 | 96
12 | 2009-12-12 00:00:00 | 88 | 88 | 94
12 | 2009-12-17 00:00:00 | 91 | 92 | 91
12 | 2009-12-22 00:00:00 | 94 | 89 | 100
12 | 2009-12-27 00:00:00 | 84 | 94 | 100
 | total | 6538 | 6593 | 6627