Spreadsheet: 110988d1307517783-2011-and-2010-ytd-monthly-sales-comparison-sample-worksheet
Sheet: top Sht

 | Summary |  |  |  |  |  |  |  |  |  |  | MANUAL ANSWER
 | ACCOUNT | Year | Jan | Feb | Mar | Apr | May | Jun | Total | YTD |  | YTD Jan | YTD Feb | [NAME] | YTD Apr | YTD May | [NAME]
 | Total MAKRO | 2010 | 1234560 | 1234560 | 1234560 | 1234560 | 1234560 | 1234560 | 7407360 | 7407360 |  | 1234560 | 2469120 | 3703680 | 4938240 | 6172800 | 7407360
 |  | 2011 | 2345670 | 2345670 | 2345670 | 2345670 | 0 | 0 | 9382680 | 9382680 |  | 2345670 | 4691340 | 7037010 | 9382680 | 9382680 | 9382680
 |  | Target | 949000 | 922720 | 1487010 | 1597240 | 1770250 | 1821350 | 8547570 | 8547570 |  | 949000 | 1871720 | 3358730 | 4955970 | 6726220 | 8547570
 |  | Growth | 1.900004860031104 | 1.900004860031104 | 1.900004860031104 | 1.900004860031104 | 0 | 0 | 1.266669906687403 | 1.266669906687403 |  | 1.900004860031104 | 1.900004860031104 | 1.900004860031104 | 1.900004860031104 | 1.520003888024883 | 1.266669906687403
 |  | Achvmnt | 2.47172813487882 | 2.542125455176001 | 1.577440635906954 | 1.468577045403321 | 0 | 0 | 1.097701451991619 | 1.097701451991619 |  | 2.47172813487882 | 2.506432586070566 | 2.095140127369571 | 1.893207586002337 | 1.394940992117415 | 1.097701451991619
 | Total SSM | 2010 | 1234560 | 1234560 | 1234560 | 1234560 | 1234560 | 1234560 | 7407360 | 7407360 |  | 1234560 | 2469120 | 3703680 | 4938240 | 6172800 | 7407360
 |  | 2011 | 2345670 | 2345670 | 2345670 | 2345670 | 0 | 0 | 9382680 | 9382680 |  | 2345670 | 4691340 | 7037010 | 9382680 | 9382680 | 9382680
 |  | Target | 1234567 | 6897040 | 8576040 | 8552680 | 7794210 | 7946780 | 41001317 | 41001317 |  | 1234567 | 8131607 | 16707647 | 25260327 | 33054537 | 41001317
 |  | Growth | 1.900004860031104 | 1.900004860031104 | 1.900004860031104 | 1.900004860031104 | 0 | 0 | 1.266669906687403 | 1.266669906687403 |  | 1.900004860031104 | 1.900004860031104 | 1.900004860031104 | 1.900004860031104 | 1.520003888024883 | 1.266669906687403
 |  | Achvmnt | 1.899994086995684 | 0.3400980710565692 | 0.2735143492800873 | 0.274261401104683 | 0 | 0 | 0.2288385029193087 | 0.2288385029193087 |  | 1.899994086995684 | 0.576926553386065 | 0.4211849819426997 | 0.3714393721031402 | 0.2838545280486004 | 0.2288385029193087
 | Total SVI | 2010 | 1234560 | 1234560 | 1234560 | 1234560 | 1234560 | 1234560 | 7407360 | 7407360 |  | 1234560 | 2469120 | 3703680 | 4938240 | 6172800 | 7407360
 |  | 2011 | 2345670 | 2345670 | 2345670 | 2345670 | 0 | 0 | 9382680 | 9382680 |  | 2345670 | 4691340 | 7037010 | 9382680 | 9382680 | 9382680
 |  | Target | 8830666.356867593 | 5725849.72200085 | 6404368.281325403 | 8580470.191496342 | 9025171.699712716 | 7972732.65503377 | 46539258.90643667 | 46539258.90643667 |  | 8830666.356867593 | 14556516.07886844 | 20960884.36019384 | 29541354.55169019 | 38566526.2514029 | 46539258.90643667
 |  | Growth | 1.900004860031104 | 1.900004860031104 | 1.900004860031104 | 1.900004860031104 | 0 | 0 | 1.266669906687403 | 1.266669906687403 |  | 1.900004860031104 | 1.900004860031104 | 1.900004860031104 | 1.900004860031104 | 1.520003888024883 | 1.266669906687403
 |  | Achvmnt | 0.2656277459940242 | 0.4096632140007204 | 0.3662609483030162 | 0.2733731308016979 | 0 | 0 | 0.2016078515316091 | 0.2016078515316091 |  | 0.2656277459940242 | 0.322284533921573 | 0.3357210449270816 | 0.3176117054342444 | 0.2432855875802062 | 0.2016078515316091
 |  | 2010 | 3703680 | 3703680 | 3703680 | 3703680 | 3703680 | 3703680 | 22222080 | 22222080 |  | 3703680 | 7407360 | 11111040 | 14814720 | 18518400 | 22222080
 |  | 2011 | 7037010 | 7037010 | 7037010 | 7037010 | 0 | 0 | 28148040 | 28148040 |  | 7037010 | 14074020 | 21111030 | 28148040 | 28148040 | 28148040
 |  | Target | 11014233.35686759 | 13545609.72200085 | 16467418.2813254 | 18730390.19149634 | 18589631.69971272 | 17740862.65503377 | 96088145.90643668 | 96088145.90643668 |  | 11014233.35686759 | 24559843.07886844 | 41027261.36019385 | 59757651.55169019 | 78347283.25140291 | 96088145.90643668
 |  | Growth | 1.900004860031104 | 1.900004860031104 | 1.900004860031104 | 1.900004860031104 | 0 | 0 | 1.266669906687403 | 1.266669906687403 |  | 1.900004860031104 | 1.900004860031104 | 1.900004860031104 | 1.900004860031104 | 1.520003888024883 | 1.266669906687403
 |  | Achvmnt | 0.6389014806565982 | 0.5195048539284615 | 0.4273292801446722 | 0.3757001284038827 | 0 | 0 | 0.2929397766443367 | 0.2929397766443367 |  | 0.6389014806565982 | 0.5730500783251926 | 0.5145610333250928 | 0.4710365830834572 | 0.3592727001098149 | 0.2929397766443367
 |  |  | What I hope would happen is that as 2011 data is inputed, the sum or total of 2010 will automatically compute that it will compare the performance from the same periods of last year.
 |  |  | if 2011 available data is Jan-Apr then it will compare Jan-April 2010