Spreadsheet: 145581d1331654386-using-sumif-test_table
Sheet: Sheet1

 |  |  |  |  |  |  | PLAIN | [NAME] | PRINT | BANDS | PRINT | [NAME] | TOTAL | TOTAL
 |  |  |  | YEAR | MONTH | WEEK | AREA | SALES | AREA | SALES | AREA | SALES | AREA | SALES
 |  |  |  | 2010 | Dec | 49 | 8981.9118 | 3430.26 | 7199.999999999999 | 5240 | 1217.1205 | 2133.34 | 17399.0323 | 10803.6
 |  |  |  |  |  | 50 | 16575.09736549495 | 6776.830000000001 | 16066.63736503287 | 11231.9 | 7054.878157454773 | 6801.410000000001 | 39696.61288798259 | 24810.14
 |  |  |  |  |  | 51 | 19605.15168 | 9603.2 | 2304 | 1516.32 | 7502.094400000001 | 8689.84 | 29411.24608 | 19809.36
 |  |  |  |  |  | 52 | 17270.25481480144 | 9434.45 | 19032.14766909667 | 12798.96 | 2947.286 | 4086.9 | 39249.68848389811 | 26320.31
 |  |  |  |  | Dec  Total |  | 62432.41566029639 | 29244.74 | 44602.78503412954 | 30787.18 | 18721.37905745477 | 21711.49 | 125756.5797518807 | 81743.41
 |  |  |  | 2010 Total |  |  | 62432.41566029639 | 29244.74 | 44602.78503412954 | 30787.18 | 18721.37905745477 | 21711.49 | 125756.5797518807 | 81743.41
 |  |  |  | 2011 | Jan | 2 | 8436.261919999999 | 4147.88 | 4605.393905817175 | 3710.77 | 864.6624999999999 | 1306.2 | 13906.31832581717 | 9164.85
 |  |  |  |  |  | 3 | 8104.0266 | 5240.960000000001 | 21611.99999999999 | 15478.06 | 3564.9493 | 5214.440000000001 | 33280.97589999999 | 25933.46000000001
 |  |  |  |  |  | 4 | 6948.892800000001 | 4167.84 | 5649.445161290323 | 2560.400000000001 | 9063.8822 | 9467.800000000003 | 21662.22016129032 | 16196.04
 |  |  |  |  |  | 5 | 9883.0656 | 3741.84 | 22633.18154836407 | 12427.1 | 2472.335 | 2821.06 | 34988.58214836407 | 18990
 |  |  |  |  |  | 6 |  |  |  |  | 5249.819999999999 | 3299.9 | 5249.819999999999 | 3299.9
 |  |  |  |  | Jan  Total |  | 33372.24692 | 17298.52 | 54500.02061547156 | 34176.33 | 21215.649 | 22109.40000000001 | 109087.9165354716 | 73584.25
 |  |  |  |  | Feb | 6 | 4119.661039550561 | 3049.97 | 12758.4 | 9017.600000000002 | 388.18736 | 1364.79 | 17266.24839955056 | 13432.36
 |  |  |  |  |  | 7 | 25762.26 | 9691.6 | 17084.5243684515 | 10581.76 | 8723.561920000004 | 7724.09 | 51570.3462884515 | 27997.45
 |  |  |  |  |  | 8 | 8386.507999999998 | 4823.440000000001 | 11624.76786469345 | 6696.080000000001 | 7638.814979359096 | 8769.260000000002 | 27650.09084405254 | 20288.78
 |  |  |  |  |  | 9 | 3548.736 | 2102.4 | 14261.743412527 | 9556.08 | 7174.921943839542 | 8717.240000000002 | 24985.40135636654 | 20375.72
 |  |  |  |  |  | 10 |  |  | 3469.142245989305 | 2510.71 | 1227.775 | 1954.9 | 4696.917245989305 | 4465.610000000001
 |  |  |  |  | Feb  Total |  | 41817.16503955055 | 19667.41 | 59198.57789166125 | 38362.23 | 25153.26120319864 | 28530.28000000001 | 126169.0041344104 | 86559.92000000001
 |  |  |  |  | Mar | 10 | 18567.989 | 8518.600000000002 | 6157.557487922704 | 4439.320000000001 | 2693.17816 | 2365.79 | 27418.72464792271 | 15323.71
 |  |  |  |  |  | 11 | 184.83 | 128.25 | 9925.71481768813 | 4854.3 | 7498.8776 | 6680.980000000001 | 17609.42241768813 | 11663.53
 |  |  |  |  |  | 12 |  |  | 18187.03852281727 | 13212.34 | 3645.876199999999 | 3461.28 | 21832.91472281727 | 16673.62
 |  |  |  |  |  | 13 | 13028.4 | 4854.570000000001 | 5901.48449197861 | 3917.72 | 15771.73097649791 | 13624.56 | 34701.61546847652 | 22396.85
 |  |  |  |  |  | 14 | 3450.118123585994 | 2194.64 | 1382.4 | 946.8000000000002 | 3961.9668 | 5573.73 | 8794.484923585995 | 8715.17
 |  |  |  |  | [NAME] |  | 35231.337123586 | 15696.06 | 41554.19532040672 | 27370.48 | 33571.62973649791 | 31706.34 | 110357.1621804906 | 74772.87999999999
 |  |  |  |  | Apr | 15 | 7325.64 | 2851.5 | 3934.4 | 2668.04 | 4018.208 | 4552.6 | 15278.248 | 10072.14
 |  |  |  |  |  | 16 | 3242.8656 | 1293.96 | 11404.8 | 7953.82 | 4882.936684800001 | 6179.500000000001 | 19530.6022848 | 15427.28
 |  |  |  |  |  | 17 | 24651.118 | 12922.4 | 12032 | 8754.16 | 5301.412 | 6714.660000000001 | 41984.53 | 28391.22
 |  |  |  |  |  | 18 | 10946.7833 | 7118.07 | 13094.4 | 7451.820000000002 | 5159.108857454772 | 5080.71 | 29200.29215745477 | 19650.6
 |  |  |  |  | Apr  Total |  | 46166.4069 | 24185.93 | 40465.6 | 26827.84 | 19361.66554225477 | 22527.47 | 105993.6724422548 | 73541.24
 |  |  |  |  | May | 19 | 10804.4136 | 4697.760000000001 | 11001.6 | 5589.88 | 3589.706 | 2565.95 | 25395.7196 | 12853.59
 |  |  |  |  |  | 20 | 5921.193600000001 | 3277.79 | 9202.560000000001 | 8204.43 | 19799.759 | 14648.95 | 34923.5126 | 26131.17
 |  |  |  |  |  | 21 | 3967.733468682505 | 1551.01 | 3225.6 | 1747.68 | 4252.463597660689 | 5058.570000000001 | 11445.7970663432 | 8357.260000000002
 |  |  |  |  |  | 22 | 151.98 | 275 | 19792.66813186812 | 14691.69 | 7517.797499999999 | 10761.2 | 27462.44563186812 | 25727.89
 |  |  |  |  |  | 23 | 7370.399999999999 | 2856.68 |  |  | 2974.105 | 4233.9 | 10344.505 | 7090.58
 |  |  |  |  | May  Total |  | 28215.7206686825 | 12658.24 | 43222.42813186812 | 30233.68 | 38133.83109766069 | 37268.57 | 109571.9798982113 | 80160.49
 |  |  |  |  | Jun | 23 | 3269.1306 | 1297.41 | 6091.199999999999 | 4553.03 | 912.4499999999999 | 858.9000000000001 | 10272.7806 | 6709.34
 |  |  |  |  |  | 24 | 12905.0172 | 6011.400000000001 | 13881.6 | 8343.72 | 6661.282080505796 | 5311.1 | 33447.89928050579 | 19666.22
 |  |  |  |  |  | 25 | 14435.676 | 7531.160000000001 | 9878.4 | 7412.2 | 10091.7 | 6917.81 | 34405.776 | 21861.17
 |  |  |  |  |  | 26 | 17232.8496 | 7927.620000000001 | 6734.400000000001 | 5511.27 | 1715.2 | 4292.219999999999 | 25682.4496 | 17731.11
 |  |  |  |  |  | 27 | 9045.22456 | 4512.76 | 13344 | 9343.28 | 2465.823 | 9101.119999999999 | 24855.04756 | 22957.16
 |  |  |  |  | [NAME] |  | 56887.89796 | 27280.35000000001 | 49929.6 | 35163.5 | 21846.4550805058 | 26481.15 | 128663.9530405058 | 88925
 |  |  |  |  | Jul | 28 | 9360.896252305307 | 4114.400000000001 | 15033.6 | 8908.56 | 1536.4 | 1542.2 | 25930.89625230531 | 14565.16
 |  |  |  |  |  | 29 | 8007.83802 | 3893.82 | 4444.786601734262 | 3532.74 | 2293.7736 | 3757.22 | 14746.39822173426 | 11183.78
 |  |  |  |  |  | 30 | 21774.98744 | 8779.470000000001 | 8928 | 5822.28 | 9195.744799999999 | 7102.250000000001 | 39898.73224 | 21704
 |  |  |  |  |  | 31 | 4094.8928 | 1887.28 | 22393.77112299465 | 14715.92 | 7801.851639999999 | 9859.64 | 34290.51556299465 | 26462.84
 |  |  |  |  | Jul  Total |  | 43238.61451230531 | 18674.97 | 50800.15772472891 | 32979.5 | 20827.77004 | 22261.31 | 114866.5422770342 | 73915.78
 |  |  |  |  | Aug | 32 | 10467.1472 | 5624.440000000001 | 7230.14601185036 | 4287.370000000001 | 6591.858747757244 | 5651.06 | 24289.1519596076 | 15562.87
 |  |  |  |  |  | 33 | 6317.7 | 2490.58 | 13636.8 | 9802.21 | 3675.87 | 4031.4 | 23630.37 | 16324.19
 |  |  |  |  |  | 34 | 537.03 | 459 | 23420.20465116279 | 15116.42 | 4492.552550000001 | 5429.230000000001 | 28449.78720116279 | 21004.65
 |  |  |  |  |  | 35 | 7015.779268682504 | 3859.35 | 4147.2 | 1898.88 | 12959.609352 | 11609.62 | 24122.5886206825 | 17367.85
 |  |  |  |  |  | 36 | 331.998 | 354 |  |  | 3526.075376497909 | 4530.160000000001 | 3858.07337649791 | 4884.160000000001
 |  |  |  |  | Aug  Total |  | 24669.6544686825 | 12787.37 | 48434.35066301315 | 31104.88 | 31245.96602625515 | 31251.47 | 104349.9711579508 | 75143.72
 |  |  |  |  | Sep | 36 | 6030 | 2206.98 | 6105.6 | 4062.320000000001 | 10980 | 4885.02 | 23115.6 | 11154.32
 |  |  |  |  |  | 37 | 2072.36 | 1093.6 | 16321.81706357955 | 13212.03 | 8160.701100000001 | 8517.16 | 26554.87816357955 | 22822.79
 |  |  |  |  |  | 38 | 8357.820624 | 4972.02 | 7876.8 | 5673.01 | 4489.64181171404 | 4318.64 | 20724.26243571404 | 14963.67
 |  |  |  |  |  | 39 | 20729.78281553398 | 11868.02 | 13114.0499177701 | 10156.83 | 11327.31418822006 | 10059.1 | 45171.14692152415 | 32083.95
 |  |  |  |  |  | 40 | 5279.1368 | 2756.54 | 11232 | 7188.510000000001 | 4455.6873 | 7880.469999999999 | 20966.8241 | 17825.52
 |  |  |  |  | Sep  Total |  | 42469.10023953398 | 22897.16 | 54650.26698134965 | 40292.7 | 39413.3443999341 | 35660.39 | 136532.7116208177 | 98850.25000000001
 |  |  |  |  | Oct | 41 | 8770.9338 | 3681.72 | 11036.05802043503 | 8378.21 | 3345.48 | 6423.860000000001 | 23152.47182043502 | 18483.79
 |  |  |  |  |  | 42 | 9090 | 3326.940000000001 | 30285.9193180987 | 21198.44000000001 | 14070.0485 | 12716.35 | 53445.9678180987 | 37241.73000000001
 |  |  |  |  |  | 43 | 22726.47716 | 10930.57 | 10477.61632653061 | 5212.04 | 10297.70140947459 | 11016.9 | 43501.7948960052 | 27159.51
 |  |  |  |  |  | 44 | 17435.0582054054 | 9166.310000000001 | 24914.56235238261 | 18507.82 | 9167.732399999999 | 9579.050000000001 | 51517.35295778801 | 37253.18
 |  |  |  |  |  | 45 |  |  |  |  | 8910.760000000002 | 7491.32 | 8910.760000000002 | 7491.32
 |  |  |  |  | Oct  Total |  | 58022.4691654054 | 27105.54 | 76714.15601744695 | 53296.51000000001 | 45791.72230947459 | 47227.48 | 180528.347492327 | 127629.53
 |  |  |  |  | Nov | 45 | 20030.226 | 9921.87 | 921.6 | 806.4000000000001 | 5570.37690947459 | 6341.110000000001 | 26522.20290947459 | 17069.38
 |  |  |  |  |  | 46 | 91.43280000000001 | 153.6 | 18527.66469248291 | 13495.6 | 4859.626 | 4505.28 | 23478.72349248291 | 18154.48
 |  |  |  |  |  | 47 | 9533.6748 | 4053.4 | 12433.1422459893 | 8857.490000000002 | 21530.6414 | 16291.56 | 43497.45844598931 | 29202.45
 |  |  |  |  |  | 48 | 15156.4586 | 8200.91 | 5218.332710280374 | 3523.68 | 12099.8324 | 13223.13 | 32474.62371028038 | 24947.72
 |  |  |  |  |  | 49 | 14205.03335 | 6656.890000000001 | 4400.389832423272 | 3438.48 | 14665.51217946247 | 12846.51 | 33270.93536188574 | 22941.88
 |  |  |  |  | Nov  Total |  | 59016.82554999999 | 28986.67 | 41501.12948117586 | 30121.65000000001 | 58725.98888893707 | 53207.59 | 159243.9439201129 | 112315.91