Spreadsheet: 727496d1617909001-sumif-with-date-range-and-vlookup-for-user-id-pco-tax-deduction-certification-2020
Sheet: Merge

Specific Investor ID | January | February | March | April | May | June | July | August | September | October | November | December | Total 2020 | 2021 | Total | End Date
26284 |  |  |  |  |  |  |  |  |  | 250000 |  |  | 250000 | 0 | 250000
26294 |  |  |  |  |  |  |  |  |  | 125000 |  |  | 125000 | 0 | 125000
37317 |  |  |  |  |  |  |  |  |  | 125000 |  |  | 125000 | 0 | 125000
37318 |  |  |  |  |  |  |  |  |  | 507236.84 |  |  | 507236.84 | 118421.05 | 625657.89
26285 |  |  |  |  |  |  |  |  |  | 250000 |  |  | 250000 | 0 | 250000
37319 |  |  |  |  |  |  |  |  |  | 125000 |  |  | 125000 | 0 | 125000
37320 |  |  |  |  |  |  |  |  |  | 500000 |  |  | 500000 | 0 | 500000
37321 |  |  |  |  |  |  |  |  |  | 250000 |  |  | 250000 | 0 | 250000
37322 |  |  |  |  |  |  |  |  |  | 175000 |  |  | 175000 | 0 | 175000
37473 |  |  |  |  |  |  |  |  |  | 250000 |  |  | 250000 | 0 | 250000
26286 |  |  |  |  |  |  |  |  |  | 125000 |  |  | 125000 | 0 | 125000
26287 |  |  |  |  |  |  |  |  |  | 375000 |  |  | 375000 | 0 | 375000
37367 |  |  |  |  |  |  |  |  |  | 183750 |  |  | 183750 | 0 | 183750
37323 |  |  |  |  |  |  |  |  |  | 250000 |  |  | 250000 | 0 | 250000
37324 |  |  |  |  |  |  |  |  |  | 553750 |  |  | 553750 | 0 | 553750
37325 |  |  |  |  |  |  |  |  |  | 125000 |  |  | 125000 | 0 | 125000
37368 |  |  |  |  |  |  |  |  |  | 125000 |  |  | 125000 | 0 | 125000
37326 |  |  |  |  |  |  |  |  |  | 150000 |  |  | 150000 | 0 | 150000
26288 |  |  |  |  |  |  |  |  |  | 50000 |  |  | 50000 | 0 | 50000
37327 |  |  |  |  |  |  |  |  |  | 250000 |  |  | 250000 | 0 | 250000
26289 |  |  |  |  |  |  |  |  |  | 250000 |  |  | 250000 | 0 | 250000
27872 |  |  |  |  |  |  |  |  |  | 125000 |  |  | 125000 | 0 | 125000
37369 |  |  |  |  |  |  |  |  |  | 187500 |  |  | 187500 | 0 | 187500
37370 |  |  |  |  |  |  |  |  |  | 62500 |  |  | 62500 | 0 | 62500
37371 |  |  |  |  |  |  |  |  |  | 125000 |  |  | 125000 | 0 | 125000
37372 |  |  |  |  |  |  |  |  |  | 150000 |  |  | 150000 | 0 | 150000
37373 |  |  |  |  |  |  |  |  |  | 125000 |  |  | 125000 | 0 | 125000
37328 |  |  |  |  |  |  |  |  |  | 50000 |  |  | 50000 | 0 | 50000
37329 |  |  |  |  |  |  |  |  |  | 125000 |  |  | 125000 | 0 | 125000
27874 |  |  |  |  |  |  |  |  |  | 250000 |  |  | 250000 | 0 | 250000
37432 |  |  |  |  |  |  |  |  |  | 62500 |  |  | 62500 | 0 | 62500
37474 |  |  |  |  |  |  |  |  |  | 125000 |  |  | 125000 | 0 | 125000
37374 |  |  |  |  |  |  |  |  |  | 125000 |  |  | 125000 | 0 | 125000
27875 |  |  |  |  |  |  |  |  |  | 250000 |  |  | 250000 | 0 | 250000
37475 |  |  |  |  |  |  |  |  |  | 125000 |  |  | 125000 | 0 | 125000
37377 |  |  |  |  |  |  |  |  |  | 500000 |  |  | 500000 | 0 | 500000
26290 |  |  |  |  |  |  |  |  |  | 75000 |  |  | 75000 | 0 | 75000
38855 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 125000 | 125000
37433 |  |  |  |  |  |  |  |  |  | 250000 |  |  | 250000 | 0 | 250000
26291 |  |  |  |  |  |  |  |  |  | 200000 |  |  | 200000 | 0 | 200000
37330 |  |  |  |  |  |  |  |  |  | 250000 |  |  | 250000 | 0 | 250000
37331 |  |  |  |  |  |  |  |  |  | 250000 |  |  | 250000 | 0 | 250000
27876 |  |  |  |  |  |  |  |  |  | 250000 |  |  | 250000 | 0 | 250000
38856 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 750000 | 750000
37332 |  |  |  |  |  |  |  |  |  | 1750000 |  |  | 1750000 | 0 | 1750000
26292 |  |  |  |  |  |  |  |  |  | 175000 |  |  | 175000 | 0 | 175000
37476 |  |  |  |  |  |  |  |  |  | 125000 |  |  | 125000 | 0 | 125000
37409 |  |  |  |  |  |  |  |  |  | 125000 |  |  | 125000 | 0 | 125000
26293 |  |  |  |  |  |  |  |  |  | 250000 |  |  | 250000 | 0 | 250000
38857 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 312500 | 312500
38858 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 125000 | 125000