Spreadsheet: 274428d1383119010-how-to-sum-value-base-on-different-dates-example
Sheet: 1

 | Wt./MR (%) | RFQ/PR Issued (10%) | T/C Evaluation (15%) | Issue of PO (15%) | NMR-1 (10%) | NMR-2 (10%) | Dlv. Lead Time (Days) | Delivery at Site (30%) | ALL NMR's (10%)
 |  | 21 | 30 | 14 | 7 |  |  |  | 50
 | 2.380952380952
 |  |  |  |  |  |  | 84 | 2014-07-01 00:00:00
 |  |  |  |  |  |  | 84 | 2014-07-01 00:00:00
 |  |  |  | 2014-02-20 00:00:00 |  |  | 112
 |  |  |  |  |  |  | 112 | 2014-07-01 00:00:00
 |  |  |  | 2014-02-20 00:00:00 |  |  | 112
 |  |  |  |  |  |  | 112 | 2014-07-01 00:00:00
 |  |  |  |  |  |  | 84 | 2014-03-03 00:00:00
 | 2.380952380952
 |  |  |  | 2014-03-18 00:00:00 |  |  | 70
 |  |  |  | 2014-03-18 00:00:00 |  |  | 70
 | 2.380952380952
 |  |  |  | 2014-03-01 00:00:00 |  |  | 70
 |  |  |  | 2014-03-01 00:00:00 |  |  | 70
 |  |  |  | 2014-03-01 00:00:00 |  |  | 70
 |  |  |  | 2014-03-01 00:00:00 |  |  | 70
 | 2.380952380952
 |  |  |  | 2014-02-25 00:00:00 |  |  | 56
 | 2.380952380952
 |  |  |  | 2014-03-31 00:00:00 |  |  | 56
 |  |  |  | 2014-03-31 00:00:00 |  |  | 56
 |  |  |  | 2014-03-31 00:00:00 |  |  | 56
 |  |  |  | 2014-03-31 00:00:00 |  |  | 56
 |  |  |  | 2014-03-31 00:00:00 |  |  | 56
 |  |  |  | 2014-03-31 00:00:00 |  |  | 56
 | 2.380952380952
 |  |  |  | 2014-04-25 00:00:00 |  |  | 42
 |  |  |  | 2014-04-25 00:00:00 |  |  | 42
 |  |  |  | 2014-04-25 00:00:00 |  |  | 42
 |  |  |  | 2014-04-25 00:00:00 |  |  | 42
 |  |  |  | 2014-04-25 00:00:00 |  |  | 42
 |  |  |  | 2014-04-25 00:00:00 |  |  | 42
 |  |  |  | 2014-04-25 00:00:00 |  |  | 28
 | 2.380952380952
 |  |  |  |  |  |  | 98 | 2014-02-15 00:00:00
 |  |  |  |  |  |  | 98 | 2014-03-11 00:00:00
 |  |  |  |  |  |  | 28 | 2014-07-09 00:00:00
 |  |  |  |  |  |  | 98 | 2014-07-05 00:00:00
 |  |  |  |  |  |  | 28 | 2014-07-09 00:00:00
 |  |  |  |  |  |  | 28 | 2014-07-09 00:00:00
 |  |  |  |  |  |  | 28 | 2014-07-09 00:00:00
 |  |  |  |  |  |  | 28 | 2014-07-09 00:00:00
 | 2.380952380952
 |  |  |  |  |  |  | 112 | 2014-03-10 00:00:00
 |  |  |  |  |  |  | 112 | 2014-03-10 00:00:00
 |  |  |  |  |  |  | 112 | 2014-03-10 00:00:00
 | 2.380952380952
 |  |  |  | 2014-04-06 00:00:00 |  |  | 70
 |  |  |  | 2014-04-06 00:00:00 |  |  | 70
 | 2.380952380952
 |  |  |  | 2013-12-24 00:00:00 |  |  | 154
 |  |  |  | 2013-12-24 00:00:00 |  |  | 154
 |  |  |  | 2013-12-24 00:00:00 |  |  | 154
 | 2.380952380952
 |  |  |  |  |  |  | 28 | 2014-06-28 00:00:00
 |  |  |  |  |  |  | 28 | 2014-06-28 00:00:00
 |  |  |  |  |  |  | 32 | 2014-06-28 00:00:00
 | 2.380952380952
 |  |  |  |  |  |  | 32 | 2014-06-28 00:00:00
 |  |  |  |  |  |  | 28 | 2014-06-28 00:00:00
 |  |  |  |  |  |  | 42 | 2014-06-28 00:00:00
 |  |  |  |  |  |  | 56 | 2014-06-28 00:00:00
 |  |  |  |  |  |  | 28 | 2014-06-28 00:00:00
 |  |  |  |  |  |  | 28 | 2014-06-28 00:00:00
 |  |  |  |  |  |  | 28 | 2014-06-28 00:00:00
 |  |  |  |  |  |  | 112 | 2014-06-28 00:00:00
 | 2.380952380952
 |  |  |  |  |  |  | 56 | 2014-06-28 00:00:00
 |  |  |  |  |  |  | 28 | 2014-06-28 00:00:00
 |  |  |  |  |  |  | 42 | 2014-06-28 00:00:00
 |  |  |  |  |  |  | 14 | 2014-06-28 00:00:00
 |  |  |  |  |  |  | 28 | 2014-06-28 00:00:00
 |  |  |  |  |  |  | 28 | 2014-06-28 00:00:00
 | 2.380952380952
 |  |  |  |  |  |  | 98 | 2014-06-28 00:00:00
 |  |  |  |  |  |  | 28 | 2014-06-28 00:00:00
 | 2.380952380952
 |  |  |  |  |  |  | 28 | 2014-06-28 00:00:00
 |  |  |  |  |  |  | 32 | 2014-06-28 00:00:00
 |  |  |  |  |  |  | 84 | 2014-06-28 00:00:00
 |  |  |  |  |  |  | 112 | 2014-06-28 00:00:00
 |  |  |  |  |  |  | 56 | 2014-06-28 00:00:00
 |  |  |  |  |  |  | 28 | 2014-06-28 00:00:00
 | 2.381
 |  |  |  |  |  |  | 84 | 2014-06-28 00:00:00
 |  |  |  |  |  |  | 154 | 2014-06-28 00:00:00
 |  |  |  |  |  |  | 56 | 2014-06-28 00:00:00
 |  |  |  |  |  |  | 28 | 2014-06-28 00:00:00
 | 2.380952380952
 |  |  |  | 2014-03-15 00:00:00 |  |  | 84
 | 2.380952380952
 |  |  |  | 2014-03-15 00:00:00 |  |  | 52
 | 2.380952380952
 |  |  |  | 2014-04-01 00:00:00 |  |  | 56
 |  |  |  | 2014-04-01 00:00:00 |  |  | 56
 |  |  |  | 2014-04-01 00:00:00 |  |  | 56
 |  |  |  | 2014-04-01 00:00:00 |  |  | 56
 |  |  |  | 2014-04-01 00:00:00 |  |  | 56
 |  |  |  | 2014-04-01 00:00:00 |  |  | 56
 | 2.380952380952
 |  |  |  | 2014-04-20 00:00:00 |  |  | 56
 | 2.380952380952
 |  |  |  |  |  |  | 56 | 2014-07-02 00:00:00
 |  |  |  |  |  |  | 56 | 2014-06-15 00:00:00
 | 2.380952380952
 |  |  |  |  |  |  | 28 | 2014-07-12 00:00:00
 |  |  |  |  |  |  | 28 | 2014-07-10 00:00:00
 |  |  |  |  |  |  | 28 | 2014-07-10 00:00:00
 | 2.380952380952
 |  |  |  | 2014-05-02 00:00:00 |  |  | 42
 | 2.380952380952
 |  |  |  |  |  |  | 42 | 2014-07-10 00:00:00
 |  |  |  | 2014-02-11 00:00:00 |  |  | 126
 |  |  |  | 2014-03-13 00:00:00 |  |  | 84
 |  |  |  |  |  |  | 126 | 2014-07-10 00:00:00
 |  |  |  |  |  |  | 70 | 2014-06-12 00:00:00
 |  |  |  |  |  |  | 42 | 2014-07-06 00:00:00
 |  |  |  |  |  |  | 42 | 2014-07-10 00:00:00
 |  |  |  | 2014-05-15 00:00:00 |  |  | 28
 |  |  |  |  |  |  | 42 | 2014-07-06 00:00:00
 |  |  |  |  |  |  | 42 | 2014-07-02 00:00:00
 |  |  |  |  |  |  | 21 | 2014-07-10 00:00:00
 |  |  |  |  |  |  | 32 | 2014-07-10 00:00:00
 |  |  |  |  |  |  | 42 | 2014-07-06 00:00:00
 |  |  |  |  |  |  | 42 | 2014-07-06 00:00:00
 | 2.380952380952
 |  |  |  | 2014-03-13 00:00:00 |  |  | 91
 |  |  |  | 2014-03-20 00:00:00 |  |  | 84
 |  |  |  |  |  |  | 42 | 2014-07-12 00:00:00
 |  |  |  | 2014-04-13 00:00:00 |  |  | 42
 | 2.380952380952
 |  |  |  |  |  |  | 32 | 2014-06-15 00:00:00
 |  |  |  |  |  |  | 32 | 2014-06-15 00:00:00
 |  |  |  |  |  |  | 32 | 2014-06-15 00:00:00
 |  |  |  |  |  |  | 32 | 2014-06-15 00:00:00
 | 2.380952380952
 |  |  |  |  |  |  | 56 | 2014-07-06 00:00:00
 |  |  |  |  |  |  | 32 | 2014-04-03 00:00:00
 | 2.380952380952
 |  |  |  |  |  |  | 56 | 2014-07-09 00:00:00
 |  |  |  |  |  |  | 42 | 2014-07-09 00:00:00
 |  |  |  |  |  |  | 32 | 2014-07-09 00:00:00
 | 2.380952380952
 |  |  |  | 2013-12-05 00:00:00 |  |  | 42
 |  |  |  |  |  |  | 91 | 2014-03-14 00:00:00
 |  |  |  |  |  |  | 56 | 2014-01-22 00:00:00
 | 2.380952380952
 |  |  |  |  |  |  | 70 | 2014-05-30 00:00:00
 |  |  |  |  |  |  | 70 | 2014-05-30 00:00:00
 | 2.380952380952
 |  |  |  |  |  |  | 70 | 2014-07-12 00:00:00
 |  |  |  |  |  |  | 56 | 2014-07-12 00:00:00
 |  |  |  |  |  |  | 56 | 2014-07-03 00:00:00
 |  |  |  |  |  |  | 91 | 2014-05-05 00:00:00
 |  |  |  |  |  |  | 42 | 2014-07-12 00:00:00
 |  |  |  |  |  |  | 56 | 2014-07-02 00:00:00
 |  |  |  |  |  |  | 56 | 2014-04-05 00:00:00
 | 2.380952380952
 |  | 2013-08-19 00:00:00 | 2013-09-09 00:00:00 | 2013-09-29 00:00:00 | 2013-10-07 00:00:00 | 2013-10-12 00:00:00 | 30 | 2013-11-30 00:00:00 | 2014-02-09 00:00:00
 | 2.380952380952
 |  |  |  | 2014-04-15 00:00:00 |  |  | 42
 |  |  |  | 2014-04-15 00:00:00 |  |  | 42
 | 2.380952380952
 |  |  |  |  |  |  | 25 | 2014-02-04 00:00:00
 |  |  |  |  |  |  | 84 | 2014-07-03 00:00:00
 | 2.380952380952
 |  |  |  |  |  |  | 25 | 2014-01-12 00:00:00
 |  |  |  |  |  |  | 25 | 2014-01-12 00:00:00
 | 2.380952380952
 |  |  |  |  |  |  | 28 | 2014-03-01 00:00:00
 |  |  |  |  |  |  | 28 | 2014-07-03 00:00:00
 | 2.380952380952
 |  |  |  |  |  |  | 84 | 2014-07-03 00:00:00
 | 2.380952380952
 |  |  |  |  |  |  | 84 | 2014-07-03 00:00:00
 | 2.380952380952
 |  |  |  |  |  |  | 56 | 2014-06-30 00:00:00
 |  |  |  |  |  |  | 84 | 2014-06-30 00:00:00
 | 2.380952380952
 |  |  |  |  |  |  | 56 | 2013-12-15 00:00:00
 |  |  |  |  |  |  | 56 | 2013-12-15 00:00:00
 |  |  |  |  |  |  | 56 | 2013-12-15 00:00:00
 | 2.380952380952
 |  |  |  |  |  |  | 56 | 2013-12-15 00:00:00
 |  |  |  |  |  |  | 56 | 2013-12-29 00:00:00
 |  |  |  |  |  |  | 56 | 2014-05-26 00:00:00
 |  |  |  |  |  |  | 28 | 2013-11-28 00:00:00
 |  |  |  |  |  |  | 28 | 2013-11-30 00:00:00
 |  |  |  |  |  |  | 28 | 2014-05-23 00:00:00
 |  |  |  |  |  |  | 28 | 2014-05-23 00:00:00
 |  |  |  |  |  |  | 28 | 2014-07-12 00:00:00
 |  |  |  |  |  |  | 28 | 2014-07-12 00:00:00
 | 2.380952380952
 |  |  |  |  |  |  | 21 | 2014-05-08 00:00:00
 |  |  |  |  |  |  | 21 | 2014-05-08 00:00:00
 |  |  |  |  |  |  | 21 | 2014-05-08 00:00:00
 |  |  |  |  |  |  | 56 | 2014-05-19 00:00:00
 |  |  |  |  |  |  | 42 | 2014-05-08 00:00:00