Spreadsheet: 80501d1280751245-index-match-formula-not-pulling-through-desired-results-agent-average-cc-2010-version-2-
Sheet: Overview

 | YTD Floor Average | 6.155124545582491
 | Name | YTD Average | January | February | March | April | May | June | July |  | # | Agent | YTD Average
 | Monthly Average |  | 6.452503060782092 | 5.75603969602133 | 5.123247539879478 | 5.798525495850277 | 7.54115831236298 | 6.717912762128086 | 5.6964849520532 |  | 1 | [NAME] | 8.63640192919273
 |  |  | 31 | 31 | 33 | 29 | 32 | 32 | 29 |  | 2 | Kamo C Maripane | 8.243492063492063
 | Hope Seemise | 5.166666666666667 | 0 | 0 | 0 | 0 | 0 | 0 | 5.166666666666667 |  | 3 | [NAME] | 8.122791828054988
 | [NAME] | 7.076871035495538 | 7.473684210526316 | 6.6 | 5.909090909090909 | 6.352941176470588 | 8.238095238095237 | 7.714285714285714 | 7.25 |  | 4 | [NAME] | 7.889369256474519
 | [NAME] | 6.679905808477237 | 6.6 | 5.1 | 5.190476190476191 | 7.230769230769231 | 8.380952380952381 | 9.523809523809524 | 4.733333333333333 |  | 5 | Innocentia Letsoalo | 7.723657628920786
 | [NAME] | 5.99234693877551 | 4.583333333333333 | 5 | 5.476190476190476 | 5.875 | 8.19047619047619 | 7.571428571428571 | 5.25 |  | 6 | [NAME] | 7.607841469921302
 | Bridget Mohale | 7.514713577738789 | 5.333333333333333 | 5.461538461538462 | 6.058823529411764 | 7.222222222222222 | 11.27777777777778 | 11.19047619047619 | 6.058823529411764 |  | 7 | Bridget Mohale | 7.514713577738789
 | [NAME] | 6.189297897521583 | 0 | 6.4375 | 5.523809523809524 | 6.222222222222222 | 6.428571428571429 | 6.05 | 6.473684210526316 |  | 8 | Ranchia Nokayi | 7.494428034371643
 | [NAME] | 6.088499025341132 | 0 | 4.684210526315789 | 4.2 | 5.888888888888889 | 7.1 | 7.157894736842105 | 7.5 |  | 9 | [NAME] | 7.076871035495538
 | [NAME] | 8.122791828054988 | 9.333333333333334 | 8.263157894736842 | 7.363636363636363 | 7.888888888888889 | 10 | 8.8 | 5.210526315789473 |  | 10 | [NAME] | 7.05
 | Danisile [NAME] | 6.777777777777778 | 0 | 0 | 0 | 0 | 0 | 0 | 6.777777777777778 |  | 11 | Nyadzawela [NAME] | 6.990910328777976
 | [NAME] | 4.718323586744639 | 0 | 2.833333333333333 | 3.75 | 4.444444444444445 | 5.421052631578948 | 5.25 | 6.611111111111111 |  | 12 | Musiwalo [NAME] | 6.958853030845512
 | [NAME] | 7.889369256474519 | 0 | 4.6 | 6.8 | 9.166666666666666 | 9.714285714285714 | 9.95 | 7.105263157894737 |  | 13 | Michelle Damons | 6.920694944644525
 | [NAME] | 5.540162292987371 | 5.5 | 6.526315789473684 | 6.352941176470588 | 4.6875 | 6.555555555555555 | 6.1 | 3.058823529411764 |  | 14 | Danisile [NAME] | 6.777777777777778
 | Glodean ([NAME]) Mekwa | 6.110099185873181 | 0 | 3.789473684210526 | 4.631578947368421 | 5.222222222222222 | 7.55 | 7.411764705882353 | 8.055555555555555 |  | 15 | [NAME] | 6.705502902915552
 | [NAME] | 5.294590643274853 | 0 | 4.2 | 4.095238095238095 | 4.833333333333333 | 5.904761904761905 | 5.684210526315789 | 7.05 |  | 16 | [NAME] | 6.679905808477237
 | Innocentia Letsoalo | 7.723657628920786 | 8.368421052631579 | 7.7 | 6.136363636363637 | 6.866666666666666 | 10.10526315789474 | 10 | 4.888888888888889 |  | 17 | [NAME] | 6.653854875283447
 | Kamo C Maripane | 8.243492063492063 | 0 | 0 | 7.428571428571429 | 8.5 | 7.444444444444445 | 9.444444444444445 | 8.4 |  | 18 | [NAME] | 6.511265909872721
 | [NAME] | 5.378863636363636 | 4.545454545454546 | 5.42 | 3.4 | 0 | 0 | 0 | 8.15 |  | 19 | [NAME] | 6.461230169898902
 | [NAME] | 6.146881910658999 | 5.277777777777778 | 5.526315789473684 | 4.3 | 4.117647058823529 | 7.684210526315789 | 8.722222222222221 | 7.4 |  | 20 | Phindile Ndhlovu | 6.400614631817639
 | [NAME] | 4.975356125356125 | 0 | 3.333333333333333 | 4.125 | 5.375 | 6.1 | 8.61111111111111 | 2.307692307692307 |  | 21 | [NAME] | 6.372803220171641
 | Lindiwe Maepa | 5.040677060297803 | 5.166666666666667 | 5.235294117647059 | 5.3125 | 5.117647058823529 | 6.052631578947368 | 5.9 | 2.5 |  | 22 | [NAME] | 6.357936507936508
 | [NAME] | 5.277669869117237 | 0 | 4.111111111111111 | 5.55 | 6.277777777777778 | 6.904761904761905 | 5.947368421052632 | 2.875 |  | 23 | [NAME] | 6.280208817670117
 | Magauta Petlele | 3.375 | 0 | 0 | 0 | 0 | 0 | 0 | 3.375 |  | 24 | [NAME] | 6.261040264058841
 | [NAME] | 4.559154295996401 | 4.153846153846154 | 3.166666666666667 | 4.611111111111111 | 3.5 | 6.266666666666667 | 4.315789473684211 | 5.9 |  | 25 | Sibusiso Sibeko | 6.241657715717866
 | [NAME] | 5.1 | 0 | 0 | 0 | 0 | 0 | 0 | 5.1 |  | 26 | Sivuyile Ngovela | 6.2
 | Michelle Damons | 6.920694944644525 | 7.333333333333333 | 7.352941176470588 | 6.111111111111111 | 7.411764705882353 | 8.25 | 6.785714285714286 | 5.2 |  | 27 | [NAME] | 6.189297897521583
 | [NAME] | 4.868123638344226 | 0 | 4.111111111111111 | 3.9 | 4.1875 | 6.277777777777778 | 4.882352941176471 | 5.85 |  | 28 | [NAME] | 6.146881910658999
 | [NAME] | 5.674928774928776 | 4.2 | 0 | 0 | 0 | 0 | 6.769230769230769 | 6.055555555555555 |  | 29 | Glodean ([NAME]) Mekwa | 6.110099185873181
 | [NAME] | 5.435524736210274 | 5.058823529411764 | 5.05 | 5.368421052631579 | 4.571428571428571 | 6.2 | 7.3 | 4.5 |  | 30 | [NAME] | 6.088499025341132
 | Musiwalo [NAME] | 6.958853030845512 | 8.157894736842104 | 7.7 | 6.272727272727272 | 8.11111111111111 | 6.375 | 7.095238095238095 | 5 |  | 31 | [NAME] | 5.99234693877551
 | [NAME] | 7.607841469921302 | 8.466666666666667 | 10 | 6.8125 | 7.333333333333333 | 6.714285714285714 | 9.705882352941176 | 4.222222222222222 |  | 32 | [NAME] | 5.735623781676413
 | [NAME] | 6.461230169898902 | 7.166666666666667 | 5.647058823529412 | 5.090909090909091 | 6.555555555555555 | 7.368421052631579 | 5.95 | 7.45 |  | 33 | [NAME] | 5.674928774928776
 | [NAME] | 5.735623781676413 | 0 | 4.9 | 4.3 | 4.611111111111111 | 6.894736842105263 | 7.157894736842105 | 6.55 |  | 34 | [NAME] | 5.540162292987371
 | [NAME] | 7.05 | 0 | 0 | 0 | 0 | 0 | 0 | 7.05 |  | 35 | [NAME] | 5.435524736210274
 | [NAME] | 6.511265909872721 | 7.157894736842105 | 6.058823529411764 | 6.157894736842105 | 6.176470588235294 | 8.777777777777779 | 6.8 | 4.45 |  | 36 | [NAME] | 5.378863636363636
 | [NAME] | 4.85 | 0 | 0 | 0 | 0 | 0 | 0 | 4.85 |  | 37 | [NAME] | 5.294590643274853
 | Nyadzawela [NAME] | 6.990910328777976 | 0 | 7.055555555555555 | 6.181818181818182 | 6.1875 | 8.8 | 8.25 | 5.470588235294118 |  | 38 | [NAME] | 5.277669869117237
 | Phindile Ndhlovu | 6.400614631817639 | 6.526315789473684 | 6.263157894736842 | 5.947368421052632 | 6.357142857142857 | 7.25 | 5.904761904761905 | 6.555555555555555 |  | 39 | [NAME] | 5.222417153996101
 | [NAME] | 6.280208817670117 | 4.846153846153846 | 5.842105263157895 | 6.1 | 6.5 | 10 | 6.117647058823529 | 4.555555555555555 |  | 40 | Hope Seemise | 5.166666666666667
 | [NAME] | 8.63640192919273 | 9.789473684210526 | 8.052631578947368 | 6.523809523809524 | 7.142857142857143 | 10.57142857142857 | 10.31578947368421 | 8.058823529411764 |  | 41 | [NAME] | 5.1
 | Ranchia Nokayi | 7.494428034371643 | 6.421052631578948 | 6.75 | 6.714285714285714 | 7.3125 | 7.809523809523809 | 9.19047619047619 | 8.263157894736842 |  | 42 | Lindiwe Maepa | 5.040677060297803
 | [NAME] | 4.645357651607651 | 0 | 3 | 4.846153846153846 | 3.8125 | 7.15 | 4.619047619047619 | 4.444444444444445 |  | 43 | [NAME] | 4.975356125356125
 | [NAME] | 6.372803220171641 | 7.052631578947368 | 8 | 6.090909090909091 | 7.388888888888889 | 6.2 | 3.210526315789474 | 6.666666666666667 |  | 44 | [NAME] | 4.868123638344226
 | [NAME] | 6.653854875283447 | 7 | 6.222222222222222 | 6.380952380952381 | 7.666666666666667 | 7.857142857142857 | 7.45 | 4 |  | 45 | [NAME] | 4.85
 | [NAME] | 4.076923076923077 | 0 | 0 | 1.5 | 0 | 3.692307692307693 | 4.615384615384615 | 6.5 |  | 46 | [NAME] | 4.718323586744639
 | Sibusiso Sibeko | 6.241657715717866 | 7.736842105263158 | 6.65 | 5.904761904761905 | 6.111111111111111 | 7.222222222222222 | 7 | 3.066666666666667 |  | 47 | [NAME] | 4.645357651607651
 | Sivuyile Ngovela | 6.2 | 0 | 0 | 0 | 0 | 0 | 0 | 6.2 |  | 48 | [NAME] | 4.559154295996401
 | [NAME] | 6.261040264058841 | 0 | 6.1 | 5.190476190476191 | 5.705882352941177 | 5.95 | 6.777777777777778 | 7.842105263157895 |  | 49 | [NAME] | 4.546110681114551
 | [NAME] | 4.546110681114551 | 0 | 3.842105263157895 | 4.647058823529412 | 4.5 | 6.5 | 5.6 | 2.1875 |  | 50 | [NAME] | 4.076923076923077
 | [NAME] | 5.222417153996101 | 0 | 3.1 | 4.578947368421052 | 4.555555555555555 | 7.2 | 8 | 3.9 |  | 51 | Magauta Petlele | 3.375
 | [NAME] | 6.705502902915552 | 7.111111111111111 | 5.157894736842105 | 5.95 | 5.294117647058823 | 8.047619047619047 | 8.277777777777779 | 7.1 |  | 52 | [NAME] | 2.266666666666667
 | [NAME] | 2.266666666666667 | 0 | 0 | 0 | 0 | 0 | 0 | 2.266666666666667
 | [NAME] | 6.357936507936508 | 0 | 3.2 | 5.714285714285714 | 6.888888888888889 | 8.4 | 8.666666666666666 | 5.277777777777778