Spreadsheet: 700016d1602899663-sum-match-and-date-association-formula-request-test
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | value | date | FORMULA RESULTS | DATE FORMULA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  | 2020-10-15 00:00:00 | 8.36 | * | 8.36 |  |  | 8.36 | 2020-10-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  | 2019-05-16 00:00:00 | 29.82 | * | 29.82 |  |  | 8.36 | 2020-10-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE] | 303.62 |  |  | 2020-10-15 00:00:00 | 9.73 | * | 9.73 |  |  | 9.73 | 2020-10-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  | 2020-10-15 00:00:00 | 4.07 | * | 4.07 |  |  | 4.07 | 2020-10-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  | 2016-08-16 00:00:00 | 25 | * | 25 |  |  | 29.83 | 2016-08-16 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  | 2016-08-16 00:00:00 | 4.83 | * | 4.83 |  |  | 29.83 | 2016-08-16 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  | 2016-08-16 00:00:00 | 28.5 | * | 28.5 |  |  | 28.5 | 2016-08-16 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  | 2016-08-16 00:00:00 | 50 | * | 50 |  |  | 50 | 2016-08-16 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  | 2016-08-16 00:00:00 | 50 | * | 50 |  |  | 50 | 2016-08-16 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  | 2013-02-01 00:00:00 | 0.44 | * | 0.44 |  |  | 50 | 2016-08-16 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  | 2016-08-16 00:00:00 | 25 | * | 25 |  |  | 25 | 2016-08-16 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  | 2016-02-02 00:00:00 | 6.07 | * | 6.07 |  |  | 25 | 2016-08-16 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  | 2013-02-01 00:00:00 | 22.52 | * | 22.52 |  |  | 25 | 2016-08-16 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  | 2017-01-31 00:00:00 | 8.95 | * | 8.95 |  |  | 8.95 | 2017-01-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE] | 1214.82 |  |  | 2017-11-21 00:00:00 | 10 | * | 10 |  |  | 15.79 | 2017-11-21 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE] | 1214.82 |  |  | 2017-11-21 00:00:00 | 5.79 | * | 5.79 |  |  | 15.79 | 2017-11-21 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  | 2017-11-21 00:00:00 | 10 | * | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  | 2016-05-25 00:00:00 | 25 | * | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  | 2017-11-21 00:00:00 | 10 | * | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  | 2017-11-21 00:00:00 | 10 | * | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  | 2014-08-11 00:00:00 | 14.75 | * | 14.75
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  | 2018-01-08 00:00:00 | 5.96 | * | 5.96
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  | 2017-01-31 00:00:00 | 12.05 | * | 12.05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE] | 943.94 |  |  | 2017-11-21 00:00:00 | 10 | * | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  | 2017-11-21 00:00:00 | 10 | * | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  |  |  | * | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE] | 300 |  |  | 2018-01-08 00:00:00 | 20.44 | * | 20.44
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  | 2017-11-21 00:00:00 | 10 | * | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  | 2017-11-21 00:00:00 | 10 | * | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  |  |  | * | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  | 2017-11-21 00:00:00 | 10 | * | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [PHONE] | 23 |  |  | 2017-11-21 00:00:00 | 10 | * | 10