Spreadsheet: 52452d1252173893-method-to-find-discrepancy-in-sumif-function-sum-if-function
Sheet: Sheet1

COST CENTRE CODE | COST CENTRE NAME | DETAILS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | Total
A1 | HR | RENTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 744.1323428245834 | 822.4295664781938 | 798.5427389713537 | 457.1460027829515 | 370.4040575250525 | 610.2367002368372 | 821.7688638603173 | 821.160828286134 | 159.3670625060317 | 838.1648411272695 | 669.6003650083337 | 87.89799363378492 | 7200.851363240843
A2 | ACCOUNT | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 428.1299795199274 | 348.9671962070915 | 598.507214310964 | 505.6386043649406 | 405.8846490516421 | 684.3843078359084 | 566.1072970285952 | 954.4727202690597 | 887.2659986970009 | 957.2397826464274 | 268.6186206085637 | 978.1153145156214 | 7583.331685055743
A3 | TRADING | ADVERTISING |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 275.0431705697985 | 284.3498743230377 | 17.56869787782378 | 281.8463022410669 | 668.6882781237645 | 852.0678815254277 | 964.2900449264212 | 192.1709056982159 | 427.1593829393759 | 72.93031615237156 | 552.6937085554429 | 151.9662307964111 | 4740.774793729158
A4 | INSURANCE | CLAIMS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 693.617447599725 | 385.4469863028946 | 960.6586420534246 | 62.46806761076829 | 891.4024887634995 | 701.0639228192988 | 545.1422695144514 | 599.7887351547346 | 721.3747563652304 | 836.7793694265054 | 127.6628035444876 | 163.0573428435389 | 6688.462831998559
A4 | INSURANCE | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 808.094367315556 | 930.5374855363968 | 698.7965724107277 | 729.6400890466748 | 754.7508286826705 | 350.9167824533028 | 581.0397168529536 | 889.4859200687914 | 697.814945479549 | 131.012917736582 | 798.9441819443038 | 17.72045329591631 | 7388.754260823424
A1 | HR | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 862.6101336145498 | 72.56387967482247 | 200.220064861818 | 587.4999257916036 | 760.9141571376283 | 479.5654732475336 | 900.1005339003844 | 199.235432119357 | 259.0968335068897 | 603.3858731024537 | 172.5275344937014 | 612.1166044171827 | 5709.836445867925
A10 | SHIPPING | PROJECT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 385.1737615905497 | 105.189356950544 | 871.1737662631575 | 449.1111328530064 | 194.4718982305384 | 296.5631785673644 | 26.30674584774284 | 536.4545081278385 | 801.9234864659919 | 333.4344856584348 | 690.7828188948138 | 651.585785238181 | 5342.170924688164
B5 | RETAIL | ENTERTAINMENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 956.7336918824942 | 553.0820357456442 | 14.67710582728987 | 707.0683932788162 | 292.3920946205041 | 813.8410271775332 | 738.1852105340843 | 149.0812188822643 | 118.960851121471 | 497.8918373709549 | 374.8220970864313 | 103.3780885052455 | 5320.113652032734
 |  | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5153.534894917184 | 3502.566381218625 | 4160.144802576559 | 3780.418517969828 | 4338.908452135301 | 4788.639273863207 | 5142.94068246495 | 4341.850268606396 | 4072.96331708154 | 4270.839423220999 | 3655.652130136078 | 2765.837813245882 | 49974.29595743655
 |  | A1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1606.742476439133 | 894.9934461530163 | 998.7628038331717 | 1044.645928574555 | 1131.318214662681 | 1089.802173484371 | 1721.869397760702 | 1020.396260405491 | 418.4638960129214 | 1441.550714229723 | 842.1278995020351 | 700.0145980509676 | 12910.68780910877
 |  | A2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 428.1299795199274 | 348.9671962070915 | 598.507214310964 | 505.6386043649406 | 405.8846490516421 | 684.3843078359084 | 566.1072970285952 | 954.4727202690597 | 887.2659986970009 | 957.2397826464274 | 268.6186206085637 | 978.1153145156214 | 7583.331685055743
 |  | A3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 275.0431705697985 | 284.3498743230377 | 17.56869787782378 | 281.8463022410669 | 668.6882781237645 | 852.0678815254277 | 964.2900449264212 | 192.1709056982159 | 427.1593829393759 | 72.93031615237156 | 552.6937085554429 | 151.9662307964111 | 4740.774793729158
 |  | A4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1501.711814915281 | 1315.984471839291 | 1659.455214464152 | 792.108156657443 | 1646.15331744617 | 1051.980705272602 | 1126.181986367405 | 1489.274655223526 | 1419.189701844779 | 967.7922871630874 | 926.6069854887913 | 180.7777961394552 | 14077.21709282198
 |  | A10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 385.1737615905497 | 105.189356950544 | 871.1737662631575 | 449.1111328530064 | 194.4718982305384 | 296.5631785673644 | 26.30674584774284 | 536.4545081278385 | 801.9234864659919 | 333.4344856584348 | 690.7828188948138 | 651.585785238181 | 5342.170924688164
 |  | B5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 956.7336918824942 | 553.0820357456442 | 14.67710582728987 | 707.0683932788162 | 292.3920946205041 | 813.8410271775332 | 738.1852105340843 | 149.0812188822643 | 118.960851121471 | 497.8918373709549 | 374.8220970864313 | 103.3780885052455 | 5320.113652032734
 |  | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5153.534894917184 | 3502.566381218625 | 4160.144802576559 | 3780.418517969828 | 4338.9084521353 | 4788.639273863207 | 5142.94068246495 | 4341.850268606396 | 4072.96331708154 | 4270.839423220999 | 3655.652130136078 | 2765.837813245882 | 49974.29595743654
 |  | HR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1606.742476439133 | 894.9934461530163 | 998.7628038331717 | 1044.645928574555 | 1131.318214662681 | 1089.802173484371 | 1721.869397760702 | 1020.396260405491 | 418.4638960129214 | 1441.550714229723 | 842.1278995020351 | 700.0145980509676 | 12910.68780910877
 |  | ACCOUNT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 428.1299795199274 | 348.9671962070915 | 598.507214310964 | 505.6386043649406 | 405.8846490516421 | 684.3843078359084 | 566.1072970285952 | 954.4727202690597 | 887.2659986970009 | 957.2397826464274 | 268.6186206085637 | 978.1153145156214 | 7583.331685055743
 |  | TRADING |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 275.0431705697985 | 284.3498743230377 | 17.56869787782378 | 281.8463022410669 | 668.6882781237645 | 852.0678815254277 | 964.2900449264212 | 192.1709056982159 | 427.1593829393759 | 72.93031615237156 | 552.6937085554429 | 151.9662307964111 | 4740.774793729158
 |  | INSURANCE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1501.711814915281 | 1315.984471839291 | 1659.455214464152 | 792.108156657443 | 1646.15331744617 | 1051.980705272602 | 1126.181986367405 | 1489.274655223526 | 1419.189701844779 | 967.7922871630874 | 926.6069854887913 | 180.7777961394552 | 14077.21709282198
 |  | SHIPPING |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 385.1737615905497 | 105.189356950544 | 871.1737662631575 | 449.1111328530064 | 194.4718982305384 | 296.5631785673644 | 26.30674584774284 | 536.4545081278385 | 801.9234864659919 | 333.4344856584348 | 690.7828188948138 | 651.585785238181 | 5342.170924688164
 |  | RETAIL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 956.7336918824942 | 553.0820357456442 | 14.67710582728987 | 707.0683932788162 | 292.3920946205041 | 813.8410271775332 | 738.1852105340843 | 149.0812188822643 | 118.960851121471 | 497.8918373709549 | 374.8220970864313 | 103.3780885052455 | 5320.113652032734
 |  | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5153.534894917184 | 3502.566381218625 | 4160.144802576559 | 3780.418517969828 | 4338.9084521353 | 4788.639273863207 | 5142.94068246495 | 4341.850268606396 | 4072.96331708154 | 4270.839423220999 | 3655.652130136078 | 2765.837813245882 | 49974.29595743655