Spreadsheet: 50052d1249467796-sales-vs-target-spreadsheet-running-subtotal-fix-example-sheet-2-jaymw-
Sheet: Sheet1

Account | Period 1 |  | Period 2 |  | Period 3 |  | Period 4 |  | Period 5 |  | Period 6 |  | All Periods (To date)
 | Sales | Target | Sales | Target | Sales | Target | Sales | Target | Sales | Target | Sales | Target | Sales | Target | %
Account 1 | 197039.7111783922 | 119663.3896621469 | 254219.6994732996 | 149816.2153794965 |  | 195505.4825113873 |  | 188763.2199822566 |  | 167848.0690438173 |  | 237819.7515475277 | 451259.4106516918 | 1059416.128126632 | 0.4259510485739487
Account 2 | 192363.1966840871 | 172635.4184495606 | 92017.77096651768 | 114986.2836498154 |  | 208341.6193773305 |  | 194396.1882222423 |  | 173871.8831743752 |  | 203094.6927028813 | 284380.9676506048 | 1067326.085576205 | 0.266442441062498
Account 3 | 216264.340305202 | 142989.379297017 | 172778.2145714868 | 106120.4111370767 |  | 134449.3241649776 |  | 132128.9995723132 |  | 146516.7991277531 |  | 129311.8630968614 | 389042.5548766888 | 791516.7763959989 | 0.4915152356569247
Account 4 | 211115.3579081387 | 155823.4115118927 | 115516.2364823013 | 109108.495088902 |  | 232235.1065286913 |  | 224881.1520462602 |  | 141479.5689193614 |  | 184366.6955329905 | 326631.59439044 | 1047894.429628098 | 0.3117027680988464
Account 5 | 319827.0858709402 | 232068.9465006215 | 293260.471162784 | 204251.2405433785 |  | 144463.6670791489 |  | 160580.0930757169 |  | 189720.4090724236 |  | 203863.7634087197 | 613087.5570337243 | 1134948.119680009 | 0.5401899403177831
Account 6 | 271121.975660134 | 209113.3541207605 | 251423.7274439538 | 208212.3268967244 |  | 227502.1381910322 |  | 228028.6896056443 |  | 167180.9339519129 |  | 166349.177034088 | 522545.7031040879 | 1206386.619800162 | 0.433149451865313
Account 7 | 135296.6264812954 | 149702.6978207212 | 287162.1068120637 | 192863.2391741294 |  | 224097.306564839 |  | 215345.551605589 |  | 203231.0557574705 |  | 133910.4193705315 | 422458.7332933591 | 1119150.27029328 | 0.3774816881227675
Account 8 | 190172.7987233078 | 121934.1703240166 | 162237.7938814601 | 100582.7522241261 |  | 126578.9763816254 |  | 172237.8077523575 |  | 196067.4547805826 |  | 227975.4763156964 | 352410.592604768 | 945376.6377784045 | 0.3727726902929589
Account 9 | 163455.9657578336 | 123663.7883710488 | 240352.0202713081 | 170730.6078668679 |  | 177884.2797672771 |  | 161822.1243672322 |  | 217976.6194247775 |  | 194234.0962044412 | 403807.9860291417 | 1046311.516001645 | 0.3859347621177353
Account 10 | 337186.6250778998 | 216067.7013403123 | 168805.9661701016 | 150336.2020662539 |  | 193805.7809755758 |  | 126555.2281267792 |  | 161644.9568950129 |  | 104077.5054315434 | 505992.5912480014 | 952487.3748354776 | 0.5312328589503889
Account 11 | 377926.6091682607 | 238115.5458179748 | 277023.8575982786 | 214878.2616671585 |  | 184218.448448734 |  | 216827.4196321557 |  | 120926.4942205004 |  | 127744.6369769121 | 654950.4667665393 | 1102710.806763435 | 0.5939458131265469
Account 12 | 258928.0242504039 | 196008.8991912499 | 276244.1206170249 | 175384.603751733 |  | 136509.3544604665 |  | 219809.7496195021 |  | 103042.6123953645 |  | 153030.9962049266 | 535172.1448674288 | 983786.2156232425 | 0.5439923190308066
Account 13 | 269613.2857422995 | 203143.4687988728 | 141286.189588787 | 149735.1345246925 |  | 180641.4763349452 |  | 229589.684720345 |  | 143631.6970926175 |  | 180009.6044064614 | 410899.4753310865 | 1086751.065877934 | 0.3780989853450389
Account 14 | 272375.6301553456 | 217132.9191524498 | 110131.7891103983 | 118465.5873969163 |  | 118257.6497092304 |  | 168794.0501607197 |  | 224436.4821408942 |  | 150411.0391505442 | 382507.4192657439 | 997497.7277107546 | 0.38346695800861
Account 15 | 205296.5869374415 | 209719.8878951026 | 154738.2331846603 | 144357.1327429869 |  | 233937.107436704 |  | 106393.0872977446 |  | 109310.2999554477 |  | 155514.2070468254 | 360034.8201221018 | 959231.7223748112 | 0.375336648824278
Account 16 | 108089.4919814985 | 130151.4734055392 | 283601.0486258718 | 233719.0008779098 |  | 193681.8198823446 |  | 131069.5552034208 |  | 214692.9558224932 |  | 218117.6071900338 | 391690.5406073703 | 1121432.412381741 | 0.3492769927841509
Account 17 | 224978.1674508759 | 208915.8987041329 | 264331.4326278476 | 166234.0559343536 |  | 121991.4951825883 |  | 140386.5927640654 |  | 199834.1852188737 |  | 224557.1392268963 | 489309.6000787235 | 1061919.36703091 | 0.4607784877742801
Account 18 | 146878.2904092629 | 110844.6709190798 | 289892.0130151777 | 223133.1148318126 |  | 211767.1250351628 |  | 109083.4677064551 |  | 181523.7359745709 |  | 232526.6808343146 | 436770.3034244406 | 1068878.795301396 | 0.4086247246595276
Account 19 | 218327.7423119596 | 138721.4197939545 | 138855.9947249093 | 151042.1320413031 |  | 163107.7704035185 |  | 110891.4918669905 |  | 208790.2462075588 |  | 144925.2086350632 | 357183.7370368688 | 917478.2689483886 | 0.389310296631082
Account 20 | 182169.9833339644 | 207479.9578555986 | 180416.1649575704 | 171116.4880650234 |  | 133310.5354814077 |  | 174287.2681113727 |  | 128796.5663166244 |  | 158153.5148727272 | 362586.1482915347 | 973144.330702754 | 0.3725923656460023
Account 21 | 211270.1399614615 | 153567.4107518556 | 237037.0400318479 | 146434.3496435763 |  | 235949.6218618038 |  | 230380.0146953816 |  | 195296.2915405348 |  | 156179.1462368822 | 448307.1799933093 | 1117806.834730034 | 0.4010596160843673
Account 22 | 302811.3114528061 | 225755.1809598616 | 111070.8342611024 | 117883.0669961184 |  | 235307.9857498836 |  | 112899.6342451351 |  | 190889.0022328838 |  | 150530.2634442847 | 413882.1457139085 | 1033265.133628167 | 0.400557545439106
Account 23 | 152480.3995625616 | 106474.6117290923 | 132097.4771481336 | 101412.4673997293 |  | 194476.3298109385 |  | 103109.1129045361 |  | 128737.8129265369 |  | 139728.2473384597 | 284577.8767106952 | 773938.5821092929 | 0.3677008528701417
Account 24 | 255735.4151035262 | 176959.2092405772 | 306328.2689545059 | 193462.0934457311 |  | 170506.8129732845 |  | 229590.0988981007 |  | 103244.1978666127 |  | 129874.0368184806 | 562063.6840580321 | 1003636.449242787 | 0.560027173666413
Account 25 | 210380.2356907792 | 205869.5369918356 | 183826.8131065874 | 174991.3452228293 |  | 123346.6991491402 |  | 197297.1991877335 |  | 163026.6392809144 |  | 204292.5106624378 | 394207.0487973666 | 1068823.930494891 | 0.3688231873839496
Account 26 | 344322.507662893 | 219565.9649082786 | 384689.3684475306 | 236159.5895440241 |  | 200865.8452852741 |  | 110849.0744951129 |  | 137580.5443902168 |  | 176023.9316878389 | 729011.8761104236 | 1081044.950310745 | 0.6743585231130952
Account 27 | 109888.8500194047 | 124153.7733818893 | 196327.9506902088 | 146898.2208038628 |  | 220074.3462210225 |  | 174825.6837719304 |  | 193780.5227327891 |  | 182998.6734776224 | 306216.8007096135 | 1042731.220389116 | 0.2936680083246597
Account 28 | 250664.7401039929 | 153072.3898171522 | 99224.83122274568 | 108922.4934048291 |  | 103835.0891753245 |  | 239501.013102569 |  | 210003.3828026826 |  | 179790.2994928666 | 349889.5713267386 | 995124.667795424 | 0.3516037564437788
Account 29 | 165289.5728159464 | 154618.6709559825 | 149111.6219641476 | 127453.171457073 |  | 104890.6180161387 |  | 228523.8948064603 |  | 238888.1703724337 |  | 196639.1653475998 | 314401.194780094 | 1051013.690955688 | 0.299140912707054
Account 30 | 169247.8287120482 | 207276.6271646352 | 373860.2535412407 | 227131.7195019819 |  | 127786.3337732497 |  | 167337.073220068 |  | 231492.6050215157 |  | 177515.0076137208 | 543108.082253289 | 1138539.366295171 | 0.4770217862739107