Spreadsheet: 785041d1656094413-need-to-summarize-data-by-date-and-multiple-criteria-2022-06-24-oeldere-barnett2000-sample-data-1
Sheet: Output

SAMPLE OUTPUT - DOES NOT INCLUDE ALL DATA FROM INPUT
Date | Company | City | State | Amount |  |  | Rijlabels | Som [NAME]
2022-05-09 00:00:00 | ABC Inc | Colorado Springs | CO | 67686.5 |  |  | ABC Inc | 317910.3200000001
2022-05-18 00:00:00 | ABC Inc | Colorado Springs | CO | 14801.04 |  |  | CO | 303176.3100000001
2022-05-24 00:00:00 | ABC Inc | Colorado Springs | CO | 27955.13 |  |  | Arvada | 0
2022-05-27 00:00:00 | ABC Inc | Colorado Springs | CO | 33223.47 |  |  | 2022-05-11 00:00:00 | 208
2022-05-11 00:00:00 | ABC Inc | Arvada | CO | 208 |  |  | 2022-05-17 00:00:00 | -208
2022-05-17 00:00:00 | ABC Inc | Arvada | CO | -208 |  |  | Avon | 25961.4
2022-05-16 00:00:00 | ABC Inc | Avon | CO | 25961.4 |  |  | 2022-05-16 00:00:00 | 25961.4
2022-05-27 00:00:00 | ABC Inc | Boulder | CO | 31815.06 |  |  | [NAME] | 16057.89
2022-05-19 00:00:00 | ABC Inc | Carbondale | CO | 837.9 |  |  | 2022-05-27 00:00:00 | 16057.89
2022-05-24 00:00:00 | ABC Inc | Casper | WY | 14734.01 |  |  | Boulder | 15757.17
 |  |  |  |  |  |  | 2022-05-27 00:00:00 | 15757.17
 |  |  |  |  |  |  | Carbondale | 837.9
 |  |  |  |  |  |  | 2022-05-19 00:00:00 | 837.9
 |  |  |  |  |  |  | Colorado Springs | 143666.14
 |  |  |  |  |  |  | 2022-05-09 00:00:00 | 67686.5
 |  |  |  |  |  |  | 2022-05-18 00:00:00 | 14801.04
 |  |  |  |  |  |  | 2022-05-24 00:00:00 | 27955.13
 |  |  |  |  |  |  | 2022-05-27 00:00:00 | 33223.47
 |  |  |  |  |  |  | Cotopaxi | 41.16
 |  |  |  |  |  |  | 2022-05-25 00:00:00 | 41.16
 |  |  |  |  |  |  | Denver | 14313.58
 |  |  |  |  |  |  | 2022-05-02 00:00:00 | 837.9
 |  |  |  |  |  |  | 2022-05-03 00:00:00 | -495
 |  |  |  |  |  |  | 2022-05-09 00:00:00 | 555.9
 |  |  |  |  |  |  | 2022-05-18 00:00:00 | 13414.78
 |  |  |  |  |  |  | Edwards | 24629
 |  |  |  |  |  |  | 2022-05-24 00:00:00 | 24629
 |  |  |  |  |  |  | [NAME] | 298.65
 |  |  |  |  |  |  | 2022-05-26 00:00:00 | 298.65
 |  |  |  |  |  |  | Frisco | 16865.06
 |  |  |  |  |  |  | 2022-05-24 00:00:00 | 16865.06
 |  |  |  |  |  |  | Highlands Ranch | 15127.12
 |  |  |  |  |  |  | 2022-05-18 00:00:00 | 15127.12
 |  |  |  |  |  |  | Littleton | 243.53
 |  |  |  |  |  |  | 2022-05-16 00:00:00 | 243.53
 |  |  |  |  |  |  | Monument | 14168.89
 |  |  |  |  |  |  | 2022-05-24 00:00:00 | 14168.89
 |  |  |  |  |  |  | Vail | 15208.82
 |  |  |  |  |  |  | 2022-05-16 00:00:00 | 15208.82
 |  |  |  |  |  |  | WY | 14734.01
 |  |  |  |  |  |  | Casper | 14734.01
 |  |  |  |  |  |  | 2022-05-24 00:00:00 | 14734.01
 |  |  |  |  |  |  | GHI Corporation | 47088.24
 |  |  |  |  |  |  | CO | 47088.24
 |  |  |  |  |  |  | [NAME] | 78.61
 |  |  |  |  |  |  | 2022-05-02 00:00:00 | 78.61
 |  |  |  |  |  |  | Canon City | 16639.73
 |  |  |  |  |  |  | 2022-05-10 00:00:00 | 16639.73
 |  |  |  |  |  |  | [NAME] | 18237.11
 |  |  |  |  |  |  | 2022-05-31 00:00:00 | 18237.11
 |  |  |  |  |  |  | Sterling | 12132.79
 |  |  |  |  |  |  | 2022-05-17 00:00:00 | 12132.79
 |  |  |  |  |  |  | (leeg) | 1094995.68
 |  |  |  |  |  |  | (leeg) | 1094995.68
 |  |  |  |  |  |  | (leeg) | 1094995.68
 |  |  |  |  |  |  | (leeg) | 1094995.68
 |  |  |  |  |  |  | Eindtotaal | 1459994.24