Spreadsheet: 784920d1656011567-need-to-summarize-data-by-date-and-multiple-criteria-sample-data-1-my-solution
Sheet: Export Data

COMPANY DATA
NA1 | NA2 | NA3 | Type | Date | NA4 | Company | NA5 | City | State | NA6 | NA7 | Amount | NA8
 |  |  | [NAME] | 2022-05-27 00:00:00 |  | ABC Inc |  | Colorado Springs | CO |  |  | 33901.5
 |  |  | [NAME] | 2022-05-27 00:00:00 |  | ABC Inc |  | Colorado Springs | CO |  |  | -678.03
 |  |  |  |  |  |  |  |  |  |  |  | 33223.47
 |  |  | [NAME] | 2022-05-02 00:00:00 |  | GHI Corporation |  | [NAME] | CO |  |  | 15.15
 |  |  | [NAME] | 2022-05-02 00:00:00 |  | GHI Corporation |  | [NAME] | CO |  |  | 63.46
 |  |  | [NAME] | 2022-05-10 00:00:00 |  | GHI Corporation |  | Canon City | CO |  |  | 16979.32
 |  |  | [NAME] | 2022-05-10 00:00:00 |  | GHI Corporation |  | Canon City | CO |  |  | -339.59
 |  |  | [NAME] | 2022-05-17 00:00:00 |  | GHI Corporation |  | Sterling | CO |  |  | 12380.4
 |  |  | [NAME] | 2022-05-17 00:00:00 |  | GHI Corporation |  | Sterling | CO |  |  | -247.61
 |  |  | [NAME] | 2022-05-18 00:00:00 |  | ABC Inc |  | Highlands Ranch | CO |  |  | 15433.8
 |  |  | [NAME] | 2022-05-18 00:00:00 |  | ABC Inc |  | Highlands Ranch | CO |  |  | -306.68
 |  |  | [NAME] | 2022-05-31 00:00:00 |  | GHI Corporation |  | [NAME] | CO |  |  | 18609.3
 |  |  | [NAME] | 2022-05-31 00:00:00 |  | GHI Corporation |  | [NAME] | CO |  |  | -372.19
 |  |  |  |  |  |  |  |  |  |  |  | 62215.36
 |  |  | [NAME] | 2022-05-02 00:00:00 |  | ABC Inc |  | Denver | CO |  |  | 855
 |  |  | [NAME] | 2022-05-02 00:00:00 |  | ABC Inc |  | Denver | CO |  |  | -17.1
 |  |  | Credit | 2022-05-03 00:00:00 |  | ABC Inc |  | Denver | CO |  |  | -495
 |  |  | [NAME] | 2022-05-09 00:00:00 |  | ABC Inc |  | Colorado Springs | CO |  |  | 13687.6
 |  |  | [NAME] | 2022-05-09 00:00:00 |  | ABC Inc |  | Colorado Springs | CO |  |  | -273.75
 |  |  | [NAME] | 2022-05-09 00:00:00 |  | ABC Inc |  | Colorado Springs | CO |  |  | 13687.6
 |  |  | [NAME] | 2022-05-09 00:00:00 |  | ABC Inc |  | Colorado Springs | CO |  |  | -273.75
 |  |  | [NAME] | 2022-05-09 00:00:00 |  | ABC Inc |  | Colorado Springs | CO |  |  | 13687.6
 |  |  | [NAME] | 2022-05-09 00:00:00 |  | ABC Inc |  | Colorado Springs | CO |  |  | -273.75
 |  |  | [NAME] | 2022-05-09 00:00:00 |  | ABC Inc |  | Colorado Springs | CO |  |  | 13553.65
 |  |  | [NAME] | 2022-05-09 00:00:00 |  | ABC Inc |  | Colorado Springs | CO |  |  | -271.07
 |  |  | [NAME] | 2022-05-09 00:00:00 |  | ABC Inc |  | Colorado Springs | CO |  |  | 14451.4
 |  |  | [NAME] | 2022-05-09 00:00:00 |  | ABC Inc |  | Colorado Springs | CO |  |  | -289.03
 |  |  | [NAME] | 2022-05-09 00:00:00 |  | ABC Inc |  | Denver | CO |  |  | 321.75
 |  |  | [NAME] | 2022-05-09 00:00:00 |  | ABC Inc |  | Denver | CO |  |  | 155
 |  |  | [NAME] | 2022-05-09 00:00:00 |  | ABC Inc |  | Denver | CO |  |  | 90.5
 |  |  | [NAME] | 2022-05-09 00:00:00 |  | ABC Inc |  | Denver | CO |  |  | -11.35
 |  |  | [NAME] | 2022-05-11 00:00:00 |  | ABC Inc |  | Arvada | CO |  |  | 212.25
 |  |  | [NAME] | 2022-05-11 00:00:00 |  | ABC Inc |  | Arvada | CO |  |  | -4.25
 |  |  | [NAME] | 2022-05-16 00:00:00 |  | ABC Inc |  | Avon | CO |  |  | 26491.22
 |  |  | [NAME] | 2022-05-16 00:00:00 |  | ABC Inc |  | Avon | CO |  |  | -529.82
 |  |  | [NAME] | 2022-05-16 00:00:00 |  | ABC Inc |  | Vail | CO |  |  | 15519.2
 |  |  | [NAME] | 2022-05-16 00:00:00 |  | ABC Inc |  | Vail | CO |  |  | -310.38
 |  |  | [NAME] | 2022-05-16 00:00:00 |  | ABC Inc |  | Littleton | CO |  |  | 248.5
 |  |  | [NAME] | 2022-05-16 00:00:00 |  | ABC Inc |  | Littleton | CO |  |  | -4.97
 |  |  | Credit | 2022-05-17 00:00:00 |  | ABC Inc |  | Arvada | CO |  |  | -212.25
 |  |  | Credit | 2022-05-17 00:00:00 |  | ABC Inc |  | Arvada | CO |  |  | 4.25
 |  |  | [NAME] | 2022-05-18 00:00:00 |  | ABC Inc |  | Colorado Springs | CO |  |  | 15103.1
 |  |  | [NAME] | 2022-05-18 00:00:00 |  | ABC Inc |  | Colorado Springs | CO |  |  | -302.06
 |  |  | [NAME] | 2022-05-18 00:00:00 |  | ABC Inc |  | Denver | CO |  |  | 13688.55
 |  |  | [NAME] | 2022-05-18 00:00:00 |  | ABC Inc |  | Denver | CO |  |  | -273.77
 |  |  | [NAME] | 2022-05-19 00:00:00 |  | ABC Inc |  | Carbondale | CO |  |  | 855
 |  |  | [NAME] | 2022-05-19 00:00:00 |  | ABC Inc |  | Carbondale | CO |  |  | -17.1
 |  |  | [NAME] | 2022-05-24 00:00:00 |  | ABC Inc |  | Edwards | CO |  |  | 25131.63
 |  |  | [NAME] | 2022-05-24 00:00:00 |  | ABC Inc |  | Edwards | CO |  |  | -502.63
 |  |  | [NAME] | 2022-05-24 00:00:00 |  | ABC Inc |  | Casper | WY |  |  | 15034.7
 |  |  | [NAME] | 2022-05-24 00:00:00 |  | ABC Inc |  | Casper | WY |  |  | -300.69
 |  |  | [NAME] | 2022-05-24 00:00:00 |  | ABC Inc |  | Frisco | CO |  |  | 17209.25
 |  |  | [NAME] | 2022-05-24 00:00:00 |  | ABC Inc |  | Frisco | CO |  |  | -344.19
 |  |  | [NAME] | 2022-05-24 00:00:00 |  | ABC Inc |  | Monument | CO |  |  | 14458.05
 |  |  | [NAME] | 2022-05-24 00:00:00 |  | ABC Inc |  | Monument | CO |  |  | -289.16
 |  |  | [NAME] | 2022-05-24 00:00:00 |  | ABC Inc |  | Colorado Springs | CO |  |  | 13693.3
 |  |  | [NAME] | 2022-05-24 00:00:00 |  | ABC Inc |  | Colorado Springs | CO |  |  | -273.87
 |  |  | [NAME] | 2022-05-24 00:00:00 |  | ABC Inc |  | Colorado Springs | CO |  |  | 14832.35
 |  |  | [NAME] | 2022-05-24 00:00:00 |  | ABC Inc |  | Colorado Springs | CO |  |  | -296.65
 |  |  | [NAME] | 2022-05-25 00:00:00 |  | ABC Inc |  | Cotopaxi | CO |  |  | 42
 |  |  | [NAME] | 2022-05-25 00:00:00 |  | ABC Inc |  | Cotopaxi | CO |  |  | -0.84
 |  |  | [NAME] | 2022-05-26 00:00:00 |  | ABC Inc |  | [NAME] | CO |  |  | 304.75
 |  |  | [NAME] | 2022-05-26 00:00:00 |  | ABC Inc |  | [NAME] | CO |  |  | -6.1
 |  |  | [NAME] | 2022-05-27 00:00:00 |  | ABC Inc |  | Boulder | CO |  |  | 16078.75
 |  |  | [NAME] | 2022-05-27 00:00:00 |  | ABC Inc |  | Boulder | CO |  |  | -321.58
 |  |  | [NAME] | 2022-05-27 00:00:00 |  | ABC Inc |  | [NAME] | CO |  |  | 16385.6
 |  |  | [NAME] | 2022-05-27 00:00:00 |  | ABC Inc |  | [NAME] | CO |  |  | -327.71
 |  |  |  |  |  |  |  |  |  |  |  | 269559.73
 |  |  |  |  |  |  |  |  |  |  |  | 364998.56
 |  |  |  |  |  |  |  |  |  |  |  | 364998.56