Spreadsheet: 50692d1250170103-how-to-summarise-the-worksheet-in-a-quicker-way-book-11
Sheet: Trf Out5(source1)

 |  | 2009-01-01 00:00:00 | 2009-02-28 00:00:00 | 2009-03-31 00:00:00 | 2009-04-30 00:00:00 | 2009-05-31 00:00:00 | 2009-06-30 00:00:00 | 2009-07-31 00:00:00 | 2009-08-31 00:00:00 | 2009-09-30 00:00:00 | 2009-10-31 00:00:00 | 2009-11-30 00:00:00 | 2009-12-31 00:00:00 | Total
 | ABC1 | 5363.767500000001 | 11669.455 | 13186.8525 | 2235.1775 | 5954.91 | 7882.5 | 6353 | 6587.446302670576 | 5421.722302670578 | 6052.697302670578 | 5427.697302670578 | 5427.697302670578 | 81562.9230133529
 | [NAME] | 1672.44283758862 | 1791.168519145175 | 1724.537400871348 | 2278.316071979638 | 1719.623746534173 | 2382.750881261954 | 2765.567794286049 | 2782.479020145217 | 4747.940755015191 | 2801.033961653256 | 2801.033961653256 | 2801.033961653256 | 30267.92891178714
 | ABC3 | 83195.95498830051 | 81891.62815395117 | 77746.68476036546 | 85344.16286840856 | 83485.17398916409 | 81270.78128088824 | 81066.71527574996 | 81858.5905337619 | 85619.97571588831 | 86105.0744460938 | 85954.51601655569 | 85794.34238425731 | 999333.600413385
 | [NAME] | 5188.103551985241 | 5395.470515941948 | 6318.583150796356 | 6272.124489926753 | 4071.296746844363 | 4508.531398921803 | 5194.461820697544 | 5015.954550262572 | 5015.954550262572 | 5045.501533069046 | 5045.501533069046 | 5645.360454551362 | 62716.84429632859
 | ABC5 | 45566.43224442918 | 34352.7457149809 | 39641.24649725798 | 45573.21916379256 | 49777.06055433877 | 46499.4002562998 | 47651.71472706793 | 64687.7520993584 | 47865.98049073645 | 47538.28010401265 | 47694.83792830714 | 47468.5403618482 | 564317.2101424299
 | ABC6 | 2472.969505815955 | 2370.33112855931 | 2449.920536051136 | 2497.77952929522 | 2613.614016639781 | 2546.953416439931 | 2149.926215072726 | 1857.391148955105 | 1857.391148955105 | 1870.544018884855 | 1870.544018884855 | 2320.438209996592 | 26877.80289355058
 | ABC7 | 1572.36938789598 | 1572.36938789598 | 1572.36938789598 | 1572.36938789598 | 1572.36938789598 | 1572.36938789598 | 1572.36938789598 | 1572.36938789598 | 1572.36938789598 | 1572.36938789598 | 1572.36938789598 | 1572.36938789598 | 18868.43265475176
 | ABC8 | 12765.59338404936 | 12846.47999628619 | 12321.94149940757 | 12572.47301036624 | 14029.75085545344 | 13179.67096596656 | 13936.85330655481 | 14727.03500279607 | 14727.03500279607 | 14045.90423857688 | 14045.90423857688 | 14045.90423857687 | 163244.545739407
 | ABC9 | 33290.98965000001 | 32599.73915 | 31933.662225 | 20082.69774479001 | 30529.72411979 | 22247.15583020999 | 32368.732475 | 26578.17654049303 | 26295.52906549302 | 26366.45031799303 | 26366.45031799303 | 26366.45031799302 | 335025.7577547551
 | ABC10 | 3425.618981398758 | 4555.916715887784 | 6754.171669559229 | 4968.993877781936 | 4642.766539028218 | 4801.996456016975 | 4475.989248977561 | 4815.982178564102 | 4815.982178564102 | 4844.56148594003 | 4824.277684980766 | 4824.277684980766 | 57750.53470168023
 | ABC11 | 92.91130713077347 | -92.91130713077347 | 0 | 0 | 0 | -510.4441707778766 | 0 | 0 | 0 | 0 | 0 | 0 | -510.4441707778766
 | ABC12 | 3932.985239099828 | 3967.73460257233 | 3895.725980991898 | 5702.372511299174 | 4898.341424798566 | 4911.252542934925 | 4759.300730750393 | 5054.237198015679 | 5054.237198015679 | 5075.84548432884 | 5075.84548432884 | 5075.84548432884 | 57403.723881465
 | ABC13 | 3348.657396246454 | 3691.587228823098 | 4087.779108952983 | 3353.561223274955 | 3269.00312851738 | 4599.583379251389 | 3343.5137828863 | 3204.331575593216 | 3204.331575593217 | 3204.331575593217 | 3204.331575593217 | 3204.331575593217 | 41715.34312591865
 | ABC14 | 34391.86223679678 | 37655.02486971496 | 36208.07813789182 | 36589.5703141018 | 36418.27120170525 | 29514.45918204462 | 36163.19495063112 | 38132.08060469951 | 38132.08060469951 | 39583.41982524619 | 39583.41982524619 | 39583.41982524618 | 441954.8815780239
 | ABC15 | 37483.50346062164 | 36684.86799464729 | 43185.99414063286 | 35839.77758954713 | 35857.30808561759 | 38037.67605572153 | 28316.49898162002 | 40295.94481554828 | 40194.08751146156 | 40509.96803467002 | 40427.76637394104 | 40344.76284119449 | 457178.1558852234
 | ABC16 | 18020.35163984924 | 17764.71178390746 | 6982.305259239556 | 35844.76944807145 | 8877.280361778045 | 20933.12118932424 | 12918.27085552354 | -9673.634709052682 | -9673.634709052682 | -9585.950722901156 | -9585.950722901156 | -9585.950722901156 | 73235.68895088472
 | ABC17 | 1217.819745542786 | 1398.593088607451 | 1494.132218077745 | 1333.573648956217 | 1353.587945802398 | 989.3446461728248 | 1306.330383849184 | 1270.097489859204 | 1270.097489859204 | 1273.855452696275 | 1273.855452696275 | 1273.855452696275 | 15455.14301481584
 | ABC18 | 3110.94100132574 | 3146.549476618799 | 4262.960429480176 | 3398.321316238818 | 3173.160738967887 | 2616.729627638478 | 3406.149995364759 | 3533.618169848065 | 3737.748735822242 | 3575.472815784217 | 3510.177301342479 | 3541.642278351036 | 41013.47188678269
 | ABC19 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | ABC20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Total | 296113.2740580768 | 293261.4620204092 | 293766.9449024721 | 305459.2596957264 | 292243.2428428759 | 287983.8323262113 | 287748.5899319279 | 292299.8519094142 | 279858.8290046761 | 279879.3592622077 | 279092.5776808341 | 279704.3210389329 | 3467411.544673764