Spreadsheet: 95650d1295268343-sumif-for-part-number-across-date-range-example
Sheet: Sheet1

Part Number |  |  |  |  |  |  |  | Date | Qty Used
MSLIC STIC I | SLIC STIC I WAX | PART01 | Out of Warranty Parts | [NAME] | PARTS | 6827 | 5859 | 2010-01-15 00:00:00 | 1 | 15 | 4.34 | 10.66 | 71.04 | 1 | 15 | 4.34 | 10.66
MSLIC STIC I | SLIC STIC I WAX | PART01 | Out of Warranty Parts | [NAME] | PARTS | 6829 | 5860 | 2010-01-15 00:00:00 | 1 | 15 | 4.34 | 10.66 | 71.04 | 2 | 30 | 8.69 | 21.31
MSLIC STIC I | SLIC STIC I WAX | PART01 | Out of Warranty Parts | [NAME] | PARTS | 6830 | 5861 | 2010-01-15 00:00:00 | 1 | 15 | 4.34 | 10.66 | 71.04 | 3 | 45 | 13.03 | 31.97
MSLIC STIC I | SLIC STIC I WAX | PART01 | Out of Warranty Parts | [NAME] | PARTS | 6831 | 5862 | 2010-01-15 00:00:00 | 1 | 15 | 4.34 | 10.66 | 71.04 | 4 | 60 | 17.38 | 42.63
MSLIC STIC I | SLIC STIC I WAX | PART01 | Out of Warranty Parts | [NAME] | PARTS | 6832 | 5863 | 2010-01-15 00:00:00 | 1 | 15 | 4.34 | 10.66 | 71.04 | 5 | 75 | 21.72 | 53.28
MSLIC STIC I | SLIC STIC I WAX | PART01 | Out of Warranty Parts | [NAME] | PARTS | 6833 | 5864 | 2010-01-15 00:00:00 | 1 | 15 | 4.34 | 10.66 | 71.04 | 6 | 90 | 26.06 | 63.94
MSLIC STIC I | SLIC STIC I WAX | PART01 | Out of Warranty Parts | [NAME] | PARTS | 6834 | 5865 | 2010-01-15 00:00:00 | 1 | 15 | 4.34 | 10.66 | 71.04 | 7 | 105 | 30.41 | 74.59
MSLIC STIC I | SLIC STIC I WAX | PART01 | Out of Warranty Parts | [NAME] | PARTS | 6835 | 5866 | 2010-01-15 00:00:00 | 1 | 15 | 4.34 | 10.66 | 71.04 | 8 | 120 | 34.75 | 85.25
MSLIC STIC I | SLIC STIC I WAX | PART01 | Out of Warranty Parts | [NAME] | PARTS | 6907 | 5876 | 2010-01-15 00:00:00 | 1 | 15 | 4.34 | 10.66 | 71.04 | 9 | 135 | 39.09 | 95.91
MSLIC STIC I | SLIC STIC I WAX | PART01 | Out of Warranty Parts | [NAME] | PARTS | 6908 | 5877 | 2010-01-15 00:00:00 | 1 | 15 | 4.34 | 10.66 | 71.04 | 10 | 150 | 43.44 | 106.56
MSLIC STIC I | SLIC STIC I WAX | PART01 | Out of Warranty Parts | [NAME] | PARTS | 6909 | 5878 | 2010-01-15 00:00:00 | 1 | 15 | 4.34 | 10.66 | 71.04 | 11 | 165 | 47.78 | 117.22
MSLIC STIC I | SLIC STIC I WAX | PART02 | Out of warranty parts | [NAME] | PARTS | 7033 | 5945 | 2010-01-15 00:00:00 | 1 | 15 | 4.34 | 10.66 | 71.04 | 12 | 180 | 52.13 | 127.88
MSLIC STIC I | SLIC STIC I WAX | PART02 | Out of warranty parts | [NAME] | PARTS | 7035 | 5946 | 2010-01-15 00:00:00 | 1 | 15 | 4.34 | 10.66 | 71.04 | 13 | 195 | 56.47 | 138.53
MSLIC STIC I | SLIC STIC I WAX | PART02 | Out of warranty parts | [NAME] | PARTS | 7036 | 5947 | 2010-01-15 00:00:00 | 1 | 15 | 4.34 | 10.66 | 71.04 | 14 | 210 | 60.81 | 149.19
MSLIC STIC I | SLIC STIC I WAX | PART02 | Out of warranty parts | [NAME] | PARTS | 7037 | 5948 | 2010-01-15 00:00:00 | 1 | 15 | 4.34 | 10.66 | 71.04 | 15 | 225 | 65.16 | 159.84
MSLIC STIC I | SLIC STIC I WAX | PART02 | Out of warranty parts | [NAME] | PARTS | 7038 | 5949 | 2010-01-15 00:00:00 | 1 | 15 | 4.34 | 10.66 | 71.04 | 16 | 240 | 69.5 | 170.5
MSLIC STIC I | SLIC STIC I WAX | PART02 | Out of warranty parts | [NAME] | PARTS | 7039 | 5950 | 2010-01-15 00:00:00 | 1 | 15 | 4.34 | 10.66 | 71.04 | 17 | 255 | 73.84 | 181.16
MSLIC STIC I | SLIC STIC I WAX | PART02 | Out of warranty parts | [NAME] | PARTS | 7529 | 6413 | 2010-01-29 00:00:00 | 1 | 15 | 4.34 | 10.66 | 71.04 | 18 | 270 | 78.19 | 191.81
MSLIC STIC I | SLIC STIC I WAX | PART02 | Out of warranty parts | [NAME] | PARTS | 7530 | 6414 | 2010-01-29 00:00:00 | 1 | 15 | 4.34 | 10.66 | 71.04 | 19 | 285 | 82.53 | 202.47
MSLIC STIC I | SLIC STIC I WAX | PART02 | Out of warranty parts | [NAME] | PARTS | 7615 | 6436 | 2010-01-29 00:00:00 | 1 | 15 | 4.34 | 10.66 | 71.04 | 20 | 300 | 86.88 | 213.13
MSLIC STIC I | SLIC STIC I WAX | PART02 | Out of warranty parts | [NAME] | PARTS | 7616 | 6437 | 2010-01-29 00:00:00 | 1 | 15 | 4.34 | 10.66 | 71.04 | 21 | 315 | 91.22 | 223.78
MSLIC STIC I | SLIC STIC I WAX | PART02 | Out of warranty parts | [NAME] | PARTS | 7618 | 6439 | 2010-01-29 00:00:00 | 1 | 15 | 4.34 | 10.66 | 71.04 | 22 | 330 | 95.56 | 234.44
MSLIC STIC I | SLIC STIC I WAX | PART02 | Out of warranty parts | [NAME] | PARTS | 7694 | 6462 | 2010-01-29 00:00:00 | 1 | 15 | 4.34 | 10.66 | 71.04 | 23 | 345 | 99.91 | 245.09
MSLIC STIC I | SLIC STIC I WAX | PART02 | Out of warranty parts | [NAME] | PARTS | 7867 | 6825 | 2010-02-05 00:00:00 | 1 | 15 | 4.34 | 10.66 | 71.04 | 24 | 360 | 104.25 | 255.75
MSLIC STIC I | SLIC STIC I WAX | PART02 | Out of warranty parts | [NAME] | PARTS | 8055 | 6831 | 2010-02-05 00:00:00 | 1 | 15 | 4.34 | 10.66 | 71.04 | 25 | 375 | 108.59 | 266.41
MSLIC STIC I | SLIC STIC I WAX | PART02 | Out of warranty parts | [NAME] | PARTS | 8068 | 6841 | 2010-02-05 00:00:00 | 1 | 15 | 4.34 | 10.66 | 71.04 | 26 | 390 | 112.94 | 277.06
MSLIC STIC I | SLIC STIC I WAX | PART02 | Out of warranty parts | [NAME] | PARTS | 8069 | 6842 | 2010-02-05 00:00:00 | 1 | 15 | 4.34 | 10.66 | 71.04 | 27 | 405 | 117.28 | 287.72
MSLIC STIC I | SLIC STIC I WAX | PART02 | Out of warranty parts | [NAME] | PARTS | 8070 | 6843 | 2010-02-05 00:00:00 | 1 | 15 | 4.34 | 10.66 | 71.04 | 28 | 420 | 121.63 | 298.38
MSLIC STIC I | SLIC STIC I WAX | PART02 | Out of warranty parts | [NAME] | PARTS | 8072 | 6844 | 2010-02-05 00:00:00 | 1 | 15 | 4.34 | 10.66 | 71.04 | 29 | 435 | 125.97 | 309.03
MSLIC STIC I | SLIC STIC I WAX | PART02 | Out of warranty parts | [NAME] | PARTS | 7804 | 6818 | 2010-02-05 00:00:00 | 1 | 15 | 4.34 | 10.66 | 71.04 | 30 | 450 | 130.31 | 319.69