Spreadsheet: 97870d1296987068-conditional-aggregation-sample
Sheet: Sheet1

Date | Amount
2011-01-01 00:00:00 | 200 |  | 2011-01-01 00:00:00 |  | specific date will be entered in cell [NAME], then all amounts related to that date
2011-01-01 00:00:00 | 200 |  |  |  | should appear in cell E2. if date is not available, then amount should be 0
2011-01-01 00:00:00 | 200
2011-01-01 00:00:00 | 200
2011-01-01 00:00:00 | 200
2011-01-01 00:00:00 | 200
2011-01-01 00:00:00 | 200
2011-01-01 00:00:00 | 200
2011-01-01 00:00:00 | 200
2011-01-01 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-02 00:00:00 | 200
2011-01-03 00:00:00 | 200
2011-01-03 00:00:00 | 200
2011-01-03 00:00:00 | 200
2011-01-03 00:00:00 | 200
2011-01-03 00:00:00 | 200
2011-01-03 00:00:00 | 200
2011-01-03 00:00:00 | 200
2011-01-03 00:00:00 | 200
2011-01-03 00:00:00 | 200
2011-01-03 00:00:00 | 200
2011-01-03 00:00:00 | 200
2011-01-03 00:00:00 | 200
2011-01-03 00:00:00 | 200
2011-01-03 00:00:00 | 200
2011-01-03 00:00:00 | 200
2011-01-03 00:00:00 | 200
2011-01-03 00:00:00 | 200
2011-01-03 00:00:00 | 200
2011-01-03 00:00:00 | 200
2011-01-03 00:00:00 | 200
2011-01-03 00:00:00 | 200
2011-01-03 00:00:00 | 200
2011-01-03 00:00:00 | 200
2011-01-03 00:00:00 | 200
2011-01-03 00:00:00 | 200
2011-01-03 00:00:00 | 200
2011-01-03 00:00:00 | 200
2011-01-03 00:00:00 | 200
2011-01-03 00:00:00 | 200
2011-01-03 00:00:00 | 200
2011-01-03 00:00:00 | 200
2011-01-04 00:00:00 | 200
2011-01-04 00:00:00 | 200
2011-01-04 00:00:00 | 200
2011-01-04 00:00:00 | 200
2011-01-04 00:00:00 | 200
2011-01-04 00:00:00 | 200
2011-01-04 00:00:00 | 200
2011-01-04 00:00:00 | 200
2011-01-04 00:00:00 | 200
2011-01-04 00:00:00 | 200
2011-01-04 00:00:00 | 200
2011-01-04 00:00:00 | 200
2011-01-05 00:00:00 | 200
2011-01-05 00:00:00 | 200
2011-01-05 00:00:00 | 200
2011-01-05 00:00:00 | 200
2011-01-05 00:00:00 | 200
2011-01-05 00:00:00 | 200
2010-01-06 00:00:00 | 200
2011-01-08 00:00:00 | 200
2011-01-08 00:00:00 | 200
2011-01-08 00:00:00 | 200
2011-01-08 00:00:00 | 200
2011-01-08 00:00:00 | 200
2011-01-08 00:00:00 | 200
2011-01-08 00:00:00 | 200
2011-01-08 00:00:00 | 200
2011-01-08 00:00:00 | 200
2011-01-08 00:00:00 | 200
2011-01-08 00:00:00 | 200
2011-01-08 00:00:00 | 200
2011-01-08 00:00:00 | 200
2011-01-08 00:00:00 | 200
2011-01-09 00:00:00 | 200
2011-01-09 00:00:00 | 200
2011-01-09 00:00:00 | 200
2011-01-09 00:00:00 | 200
2011-01-09 00:00:00 | 200
2011-01-09 00:00:00 | 200
2011-01-09 00:00:00 | 200
2011-01-09 00:00:00 | 200
2011-01-09 00:00:00 | 200
2011-01-09 00:00:00 | 200
2011-01-09 00:00:00 | 200
2011-01-09 00:00:00 | 200
2011-01-10 00:00:00 | 200
2011-01-10 00:00:00 | 200
2011-01-10 00:00:00 | 200