Spreadsheet: 220656d1363215986-formual-with-2-criteria-using-sumif-and-a-date-range-sumifsdaterange
Sheet: Sheet1

REP | Date | INV # | SELL TOTAL | GP$ | GPD % | RUNNING MONTHLY TOTAL |  |  | Shad |  | [NAME] |  | [NAME] |  | Justin |  | [NAME] |  | [NAME]
 |  |  |  |  |  |  |  |  | GD Sales | GP Dollars | GD Sales | GP Dollars | GD Sales | GP Dollars | GD Sales | GP Dollars | GD Sales | GP Dollars | GD Sales | GP Dollars
 |  |  |  |  |  |  |  | January
 |  |  |  |  |  |  |  | February
 |  |  |  |  |  |  |  | March
 |  |  |  |  |  |  |  | April
 |  |  |  |  |  |  |  | May
 |  |  |  |  |  |  |  | June
 |  |  |  |  |  |  |  | July
 |  |  |  |  |  |  |  | August
 |  |  |  |  |  |  |  | September
 |  |  |  |  |  |  |  | October
 |  |  |  |  |  |  |  | November
 |  |  |  |  |  |  |  | December
DB | 2013-02-28 00:00:00 | 202755 | 357.75 | 160.69
 |  |  |  |  |  |  |  | NOTE: I want to apply the GP$ to each month and GD Sales for each month by date.
SM | 2013-03-01 00:00:00 | 202739 | 1575 | 258.75 |  |  |  | So, If you look at Shad, I want to show GD Sales (column D) and GP Dollars (Column E) but by the MONTH date range.
MW | 2013-02-27 00:00:00 | 202735 | 1745.6 | 38.16
MW | 2013-03-01 00:00:00 | 202740 | 7920 | 1040 |  |  |  | DATE RANGE (Inclusive)
MW | 2013-03-01 00:00:00 | 202741 | 16240 | 2240 |  |  |  | FROM | 2013-03-01 00:00:00
MW | 2013-03-01 00:00:00 | 202757 | 1160.2 | 457.2 |  |  |  | TO | 2013-03-31 00:00:00
MW | 2013-03-01 00:00:00 | 202759 | 687.5 | 575
KB | 2013-02-28 00:00:00 | 202745 | 1766.7 | 370.87
KB | 2013-02-28 00:00:00 | 202747 | 4710.63 | 1424.95
KB | 2013-02-28 00:00:00 | 202750 | 12257.57 | 2158.09
KB | 2013-02-28 00:00:00 | 202753 | 164.5 | 95.9
KB | 2013-02-28 00:00:00 | 202754 | 211.5 | 123.3
KB | 2013-02-28 00:00:00 | 202806 | 183.96 | 102.2
KB | 2013-02-28 00:00:00 | 202756 | 50.93 | 24.28
KB | 2013-03-01 00:00:00 | 202738 | 344.1 | 96.6
KB | 2013-03-01 00:00:00 | 202758 | 108.16 | 10.8
KB | 2013-03-01 00:00:00 | 202761 | 407.5 | 37.79
KB | 2013-01-31 00:00:00 | 202231 | 52.5 | 15.19
KB | 2013-02-28 00:00:00 |  | 68.9 | 34.6
KB | 2013-02-28 00:00:00 |  | 283 | 183.17
KB | 2013-03-04 00:00:00 |  | 2311.51 | 1130.64
KB | 2013-03-04 00:00:00 |  | 628.5 | 42
DB | 2013-03-04 00:00:00 |  | 472 | 17.5
MW | 2013-03-04 00:00:00 |  | 1092.8 | 720
MW | 2013-03-04 00:00:00 |  | 1650 | 500
MW | 2013-02-28 00:00:00 |  | 433.4 | 69.48
MW | 2013-02-27 00:00:00 |  | 8814.2 | 1205.3
MW | 2013-02-21 00:00:00 |  | 3234 | 741.3
SM | 2013-03-04 00:00:00 |  | 155.1 | 31.02
KB | 2013-03-05 00:00:00 | 202835 | 9926.74 | 5631.16
KB | 2013-03-05 00:00:00 | 202836 | 227.16 | 99.36
KB | 2013-03-05 00:00:00 | 202840 | 1023.75 | 370.89
KB | 2013-03-05 00:00:00 | 202827 | 945 | 54
KB | 2013-03-01 00:00:00 | 202824 | 1400 | 406
KB | 2013-03-05 00:00:00 | 202826 | 105 | 6
KB | 2013-03-05 00:00:00 | 202829 | 1226.13 | 124.52 |  | SPLIT
KB | 2013-03-05 00:00:00 | 202831 | 1564.44 | 150.34 |  | SPLIT
KB | 2013-03-05 00:00:00 | 202833 | 3846.86 | 235.76
KB | 2013-02-28 00:00:00 | 202792 | 282.39 | 85.73
KB | 2013-02-28 00:00:00 | 202765 | 4612.92 | 1124.79
KB | 2013-02-28 00:00:00 | 202782 | 73.2 | 27.75
KB | 2013-02-28 00:00:00 | 202766 | 818 | 223.1
KB | 2013-02-28 00:00:00 | 202769 | 5409.14 | 883
KB | 2013-03-06 00:00:00 | 202844 | -270.3 | -43.99
DB | 2013-02-28 00:00:00 | 202768 | 51.68 | 18.88
DB | 2013-02-28 00:00:00 | 202767 | 333.16 | 121.47
DB | 2013-03-05 00:00:00 | 202831 | 1042.96 | 100.22 |  | SPLIT
DB | 2013-03-05 00:00:00 | 202829 | 817.41 | 83.02 |  | SPLIT
MW | 2013-03-06 00:00:00 | 202847 | -46 | -30
MW | 2013-03-05 00:00:00 | 202841 | 21 | 9.71
MW | 2013-03-01 00:00:00 | 202823 | 490 | 102.5
SM | 2013-03-05 00:00:00 | 202830 | 1605 | 153.75
SM | 2013-03-05 00:00:00 | 202834 | 228 | 12
SCG | 2013-03-05 00:00:00 | 202832 | 1704 | 804
KB | 2013-03-06 00:00:00 | 202864 | 231.67 | 225.6
KB | 2013-03-06 00:00:00 | 202863 | 154.7 | 43.75
KB | 2013-03-06 00:00:00 | 202861 | 2229.53 | 243.53
KB | 2013-02-28 00:00:00 | 202776 | 5187 | 1187
KB | 2013-02-28 00:00:00 | 202805 | 3505 | 957.45
KB | 2013-02-28 00:00:00 | 202763 | 1395 | 596
KB | 2013-03-06 00:00:00 | 202856 | 1023.75 | 236.25
KB | 2013-03-05 00:00:00 | 202843 | 270.3 | 27.37
KB | 2013-02-28 00:00:00 | 202781 | 76 | 46.88
KB | 2013-02-27 00:00:00 | 202683 | 1432 | 788
KB | 2013-03-06 00:00:00 | 202846 | -217 | -70 |  | This was the difference in the original charged amount and new price amount
DB | 2013-03-06 00:00:00 | 202862 | 712.5 | 447.5
DB | 2013-03-07 00:00:00 | 202865 | -652.5 | -105
DB | 2013-02-28 00:00:00 | 202778 | 652.5 | 105
SM | 2013-02-28 00:00:00 | 202787 | 4473.6 | 384.51
SM | 2013-03-06 00:00:00 | 202859 | 1706.32 | 446.32
SM | 2013-03-06 00:00:00 | 202855 | 1365 | 210
MW | 2013-03-05 00:00:00 | 202839 | 115.92 | 52.84
MW | 2013-03-06 00:00:00 | 202860 | 277.12 | 50.24
MW | 2013-03-05 00:00:00 | 202850 | 4840 | 583
SM | 2013-03-01 00:00:00 | 202869 | 1980.71 | 545
SM | 2013-03-07 00:00:00 | 202879 | 1898.88 | 622.33
SM | 2013-03-07 00:00:00 | 202885 | 1803 | 715.96
SM | 2013-03-07 00:00:00 | 202883 | 105 | 1.9
SM | 2013-03-07 00:00:00 | 202882 | 1965.15 | 33.75
SM | 2013-03-07 00:00:00 | 202889 | 728.4 | 78.35
MW | 2013-03-04 00:00:00 | 202868 | 1597.4 | 189
MW | 2013-03-04 00:00:00 | 202867 | 864 | 307.8
MW | 2013-03-04 00:00:00 | 202870 | 516 | 10.48
MW | 2013-03-06 00:00:00 | 202871 | 21950 | 3620
MW | 2013-03-07 00:00:00 | 202872 | 446.8 | 65.12
MW | 2013-03-07 00:00:00 | 202873 | 2682.35 | 383.81
MW | 2013-03-07 00:00:00 | 202876 | 948.03 | 292.95
MW | 2013-03-07 00:00:00 | 202877 | 560.66 | 129
MW | 2013-03-07 00:00:00 | 202890 | 120.8 | 94
KB | 2013-03-07 00:00:00 | 202875 | 285 | 95.2
KB | 2013-03-07 00:00:00 | 202880 | 424 | 120
KB | 2013-03-07 00:00:00 | 202881 | 4465.5 | 451.66
KB | 2013-03-07 00:00:00 | 202884 | 994.98 | 200.76
KB | 2013-03-07 00:00:00 | 202887 | 137.47 | 46.61
KB | 2013-03-07 00:00:00 | 202891 | 156.25 | -11.41
KB | 2013-03-07 00:00:00 | 202893 | 270.75 | 200.98
KB | 2013-02-28 00:00:00 | 202785 | 7155.35 | 1263.73 |  |  | Revised
DB | 2013-03-07 00:00:00 | 202874 | 308.26 | 24.76
DB | 2013-02-28 00:00:00 | 202802 | 3699 | 259.94
DB | 2013-02-28 00:00:00 | 202804 | 5100.27 | 2098.94
KB | 2013-03-08 00:00:00 | 202898 | 48.75 | 20.62
KB | 2013-03-08 00:00:00 | 202900 | 926.25 | 91.5
KB | 2013-03-08 00:00:00 | 202902 | 135.9 | 77.4 |  | SPLIT
KB | 2013-03-08 00:00:00 | 202906 | 8497.4 | 284.98
KB | 2013-03-08 00:00:00 | 202915 | 250.5 | 138.6
DB | 2013-03-08 00:00:00 | 202895 | 591.2 | 210.45
DB | 2013-03-08 00:00:00 | 202902 | 90.6 | 51.6 |  | SPLIT
MW | 2013-03-08 00:00:00 | 202908 | 131.4 | 28.4
MW | 2013-03-08 00:00:00 | 202909 | 451.48 | 135.02
MW | 2013-03-08 00:00:00 | 202913 | 152.25 | 137.55
SM | 2013-03-08 00:00:00 | 202896 | 1966.25 | 157.62
SM | 2013-03-08 00:00:00 | 202897 | 630 | 130.5
SM | 2013-03-08 00:00:00 | 202901 | 594 | 82.5
SM | 2013-02-28 00:00:00 | 202779 | 20431.44 | 4892.26
KB | 2013-02-28 00:00:00 | 202773 | 3556.59 | 1679.94
KB | 2013-02-28 00:00:00 | 202791 | 581.33 | 124.82
KB | 2013-03-07 00:00:00 | 202918 | 990 | 210.6
KB | 2013-03-11 00:00:00 | 202924 | 210 | 120 |  | Split
KB | 2013-03-11 00:00:00 | 202925 | 279 | 56
KB | 2013-02-28 00:00:00 | 202784 | 1375 | 265.5
KB | 2013-03-11 00:00:00 | 202931 | 157.52 | 80
KB | 2013-02-28 00:00:00 | 202774 | 3065.3 | 1252.12
KB | 2013-02-28 00:00:00 | 202770 | 836.9 | 368.09
DB | 2013-03-11 00:00:00 | 202922 | 288 | -282.24
DB | 2013-03-11 00:00:00 | 202929 | 206.7 | 90
DB | 2013-03-11 00:00:00 | 202924 | 140 | 80 |  | Split
SM | 2013-03-05 00:00:00 | 202919 | 26450 | 4370
SM | 2013-03-11 00:00:00 | 202934 | 732 | 48.5
SM | 2013-03-11 00:00:00 | 202927 | 3408 | 306.37
SM | 2013-03-11 00:00:00 | 202928 | 4625.97 | 15.91
SM | 2013-03-11 00:00:00 | 202930 | 1720 | 1265.51
SM | 2013-03-12 00:00:00 | 202935 | 2082 | 522
MW | 2013-03-06 00:00:00 | 202921 | 458 | 91
MW | 2013-03-08 00:00:00 | 202920 | 2545.56 | 563.28
MW | 2013-03-11 00:00:00 | 202926 | 7758 | 5538
MW | 2013-03-11 00:00:00 | 202932 | 836.8 | 280
MW | 2013-03-11 00:00:00 | 202933 | 8216.28 | 1316.88
KB | 2013-03-12 00:00:00 | 202937 | 1205.1 | 105.3 |  | SPLIT
KB | 2013-03-12 00:00:00 | 202940 | 262.5 | 15
KB | 2013-03-12 00:00:00 | 202942 | 514.28 | 92.88
KB | 2013-03-12 00:00:00 | 202945 | 189.55 | 82.92
KB | 2013-03-12 00:00:00 | 202947 | 131.25 | 76.5
KB | 2013-02-28 00:00:00 | 202786 | 13956.14 | 2132.96
KB | 2013-01-31 00:00:00 | 202225 | 540.5 | 276.18
KB | 2013-03-12 00:00:00 | 202946 | 39.5 | -11.11
KB | 2013-02-28 00:00:00 | 202762 | 5570.59 | 2098.8
SM | 2013-03-12 00:00:00 | 202941 | 3150 | 196.8
SM | 2013-03-12 00:00:00 | 202943 | 7.8 | -5.5
SM | 2013-03-12 00:00:00 | 202951 | 3527.81 | 218.92
SM | 2013-03-12 00:00:00 | 202952 | 950 | 143.79
DB | 2013-03-12 00:00:00 | 202944 | 83.05 | 48.78
DB | 2013-03-12 00:00:00 | 202937 | 803.4 | 70.2 |  | SPLIT
MW | 2013-03-12 00:00:00 | 202950 | 335.9 | 73.1
TD | 2013-03-11 00:00:00 | 202939 | 8461.3 | 592.1