Spreadsheet: 79252d1279549214-sumif-not-adding-correctly-agent-average-cc-2010
Sheet: June

 |  |  |  |  |  | Saturday |  |  |  |  |  | Saturday |  |  |  |  | Saturday |  |  |  |  |  | Saturday |  |  |  |  |  |  |  | Ranking |  |  | Agent Ranking on Sales
Agent Name | AB Number | Team Leader | 2010-06-30 00:00:00 | 2010-06-29 00:00:00 | 2010-06-28 00:00:00 | 2010-06-26 00:00:00 | 2010-06-25 00:00:00 | 2010-06-24 00:00:00 | 2010-06-23 00:00:00 | 2010-06-22 00:00:00 | 2010-06-21 00:00:00 | 2010-06-19 00:00:00 | 2010-06-18 00:00:00 | 2010-06-17 00:00:00 | 2010-06-15 00:00:00 | 2010-06-14 00:00:00 | 2010-06-12 00:00:00 | 2010-06-11 00:00:00 | 2010-06-10 00:00:00 | 2010-06-09 00:00:00 | 2010-06-08 00:00:00 | 2010-06-07 00:00:00 | 2010-06-05 00:00:00 | 2010-06-04 00:00:00 | 2010-06-03 00:00:00 | 2010-06-02 00:00:00 | 2010-06-01 00:00:00 | Monthly Average | Monthly average (Excl Saturdays) | Consultant | Monthly Average (Excl Saturday) | Sales |  | # | Consultant | Sales
[NAME] | EXAM322 | [NAME] | 5 | 9 | 9 | 4 | 9 | 4 | 7 | 12 | 6 |  | 3 | 7 | 5 | 6 |  | 6 | 6 | 7 | 10 | 6 | 6 | 9 | 11 | 12 | 13 | 7.478260869565218 | 7.714285714285714 | Bridget Mohale | 11.19047619047619 | 245 |  | 1 | Bridget Mohale | 245
[NAME] | ABLP420 | [NAME] | 6 | 8 | 11 | 5 | 10 | 8 | 5 | 9 | 11 | 4 | 10 | 11 | 6 | 12 |  | 2 | 7 | 11 | 12 | 11 | 6 | 10 | 13 | 16 | 11 | 8.958333333333334 | 9.523809523809524 | [NAME] | 10.31578947368421 | 208 |  | 2 | Innocentia Letsoalo | 220
[NAME] | ABBT137 | [NAME] | 6 | 12 | 11 | 3 | 10 | 6 | 7 | 2 | 6 |  | 8 | 8 | 6 | 8 |  | 3 | 10 | 4 | 7 | 8 | 5 | 8 | 8 | 10 | 11 | 7.260869565217392 | 7.571428571428571 | Innocentia Letsoalo | 10 | 220 |  | 3 | [NAME] | 215
Bridget Mohale | [NAME] | [NAME] | 3 | 15 | 14 |  | 12 | 12 | 8 | 8 | 13 | 4 | 14 | 13 | 12 | 11 |  | 3 | 13 | 12 | 12 | 13 | 6 | 9 | 10 | 17 | 11 | 10.65217391304348 | 11.19047619047619 | [NAME] | 9.95 | 210 |  | 4 | [NAME] | 210
[NAME] | ABCW433 | [NAME] | 5 | 7 | 3 |  | 5 | 4 |  | 3 | 4 | 1 | 2 | 6 | 6 | 4 | 2 | 2 | 6 | 6 | 8 | 10 |  | 5 | 12 | 9 | 14 | 5.636363636363637 | 6.05 | [NAME] | 9.705882352941176 | 172 |  | 5 | [NAME] | 208
[NAME] | EXDM277 | [NAME] | 2 | 10 | 6 |  | 7 | 6 | 7 | 10 | 10 | 1 | 4 | 5 | 7 | 5 |  | 9 | 7 | 11 | 10 | 9 | 2 | 10 | 1 |  |  | 6.619047619047619 | 7.157894736842105 | [NAME] | 9.523809523809524 | 215 |  | 6 | Ranchia Nokayi | 200
[NAME] | ABDV180 | [NAME] | 7 | 12 | 9 | 5 | 10 | 8 |  | 12 | 6 |  | 9 | 9 | 6 | 11 |  | 8 | 5 | 8 | 10 | 9 | 5 | 11 | 1 | 12 | 13 | 8.454545454545455 | 8.8 | Kamo C Maripane | 9.444444444444445 | 180 |  | 7 | [NAME] | 194
[NAME] | EXNB190 | Marinda du Plessis | 5 | 8 | 4 | 2 | 7 | 8 | 8 | 7 | 3 |  | 4 | 3 | 4 | 4 | 1 | 2 |  | 4 | 3 | 1 |  | 9 | 6 | 4 | 11 | 4.909090909090909 | 5.25 | Ranchia Nokayi | 9.19047619047619 | 200 |  | 8 | [NAME] | 186
[NAME] | EXEM221 | [NAME] | 7 | 12 | 11 | 6 | 9 | 10 | 7 | 12 | 7 |  | 7 | 7 | 7 | 11 |  |  | 9 | 10 | 10 | 12 | 5 | 12 | 12 | 13 | 14 | 9.545454545454545 | 9.95 | [NAME] | 8.8 | 186 |  | 9 | Kamo C Maripane | 180
[NAME] | ABFH099 | [NAME] | 7 | 7 | 6 |  | 4 | 2 | 2 | 5 | 3 | 2 | 5 | 7 |  | 8 | 1 | 2 | 8 | 7 | 7 | 5 |  | 6 | 9 | 12 | 10 | 5.681818181818182 | 6.1 | [NAME] | 8.722222222222221 | 167 |  | 10 | [NAME] | 172
Glodean ([NAME]) Mekwa | EXGM103 | [NAME] |  | 4 | 4 |  |  |  |  | 6 | 8 | 2 | 8 | 4 | 8 | 9 |  | 8 | 8 | 11 | 10 | 7 | 6 | 6 | 7 | 9 | 9 | 7.052631578947368 | 7.411764705882353 | [NAME] | 8.666666666666666 | 194 |  | 11 | [NAME] | 172
[NAME] | EXGM232 | Marinda du Plessis | 2 | 7 | 6 | 4 | 4 | 5 | 6 | 2 | 5 |  | 10 | 4 | 2 | 7 |  | 3 | 4 |  |  | 2 | 5 | 7 | 8 | 13 | 11 | 5.571428571428571 | 5.684210526315789 | [NAME] | 8.61111111111111 | 167 |  | 12 | Nyadzawela [NAME] | 171
Innocentia Letsoalo | EXIL107 | [NAME] | 4 | 12 | 8 |  | 7 | 7 | 8 | 9 | 12 | 6 | 12 | 12 | 10 | 12 |  | 8 | 10 | 11 | 11 | 10 | 4 | 12 | 11 | 11 | 13 | 9.565217391304348 | 10 | [NAME] | 8.277777777777779 | 158 |  | 13 | [NAME] | 167
Kamo C Maripane | ABKM964 | 0 | 6 | 11 | 11 | 5 |  | 10 | 8 | 9 | 7 |  | 9 | 9 | 8 | 10 |  |  |  | 9 | 8 | 8 | 5 | 10 | 10 | 14 | 13 | 9 | 9.444444444444445 | Nyadzawela [NAME] | 8.25 | 171 |  | 14 | [NAME] | 167
[NAME] | ABKM782 | [NAME] |  |  | 7 |  |  | 7 | 8 | 9 | 8 | 3 | 7 | 9 | 11 | 7 |  | 8 | 11 | 10 | 9 | 7 | 7 | 6 | 9 | 9 | 15 | 8.35 | 8.722222222222221 | [NAME] | 8 | 164 |  | 15 | [NAME] | 167
[NAME] | EXLN222 | [NAME] |  |  | 8 |  | 6 | 8 |  | 9 | 10 | 7 | 7 | 9 | 10 | 9 |  | 7 | 11 | 10 | 11 | 10 | 5 | 10 | 7 | 8 | 5 | 8.35 | 8.61111111111111 | [NAME] | 7.714285714285714 | 172 |  | 16 | [NAME] | 164
Lindiwe Maepa | ABFM329 | [NAME] | 5 | 8 | 3 |  | 5 | 1 | 6 | 3 | 4 |  | 4 | 3 |  | 9 |  | 3 | 6 | 7 | 7 | 8 |  | 6 | 8 | 9 | 13 | 5.9 | 5.9 | [NAME] | 7.571428571428571 | 167 |  | 17 | [NAME] | 158
[NAME] | EXGM138 | [NAME] | 3 |  |  |  | 3 | 5 | 2 | 5 | 3 | 1 | 5 | 7 | 10 | 5 | 2 | 3 | 7 | 7 | 5 | 8 |  | 7 | 7 | 8 | 13 | 5.523809523809524 | 5.947368421052632 | [NAME] | 7.45 | 158 |  | 18 | [NAME] | 158
[NAME] | ABMH452 | Marinda du Plessis | 4 | 4 | 4 | 1 | 4 |  |  | 3 | 7 |  | 2 | 6 | 4 | 2 |  | 2 | 1 | 4 | 5 | 6 | 1 | 7 | 5 | 5 | 7 | 4 | 4.315789473684211 | Glodean ([NAME]) Mekwa | 7.411764705882353 | 134 |  | 19 | Musiwalo [NAME] | 156
Michelle Damons | ABMD419 | [NAME] | 4 | 10 | 4 |  |  | 6 | 6 | 6 | 9 | 2 | 5 |  | 9 | 5 | 4 |  |  |  | 1 |  |  | 9 | 11 |  | 10 | 6.3125 | 6.785714285714286 | [NAME] | 7.3 | 79 |  | 20 | Sibusiso Sibeko | 143
[NAME] | EXMM922 | [NAME] | 3 | 4 | 2 |  | 3 | 1 | 3 | 3 | 5 |  | 5 | 4 | 6 | 6 |  |  |  |  | 5 | 8 |  | 6 |  | 9 | 10 | 4.882352941176471 | 4.882352941176471 | [NAME] | 7.157894736842105 | 139 |  | 21 | [NAME] | 140
[NAME] | ABMMBKY | [NAME] | 8 | 11 | 5 |  | 6 | 3 | 6 | 9 |  |  |  |  | 12 | 6 | 1 | 5 | 11 | 2 | 4 |  |  |  |  |  |  | 6.357142857142857 | 6.769230769230769 | [NAME] | 7.157894736842105 | 140 |  | 22 | [NAME] | 139
[NAME] | ABMMBAO | [NAME] | 3 | 7 | 7 |  | 7 | 6 |  |  | 13 | 6 | 7 | 8 | 11 | 4 |  |  |  |  |  |  |  |  |  |  |  | 7.181818181818182 | 7.3 | Musiwalo [NAME] | 7.095238095238095 | 156 |  | 23 | [NAME] | 138
Musiwalo [NAME] | ABMT654 | 0 | 5 | 9 | 9 | 4 | 9 | 7 | 7 | 5 | 7 |  | 7 | 6 | 7 | 6 |  | 5 | 6 | 6 | 6 | 6 | 3 | 9 | 8 | 10 | 9 | 6.782608695652174 | 7.095238095238095 | Sibusiso Sibeko | 7 | 143 |  | 24 | Glodean ([NAME]) Mekwa | 134
[NAME] | ABNK365 | 0 | 1 | 8 | 9 |  |  |  | 9 | 9 | 11 | 7 | 5 | 12 | 10 | 11 |  | 8 | 11 | 10 | 13 |  |  |  | 12 | 14 | 12 | 9.555555555555555 | 9.705882352941176 | [NAME] | 6.8 | 138 |  | 25 | [NAME] | 131
[NAME] | ABNMADZ | [NAME] | 5 | 9 | 5 | 3 | 8 | 7 | 4 | 6 | 6 |  | 5 | 5 | 5 | 2 |  |  | 5 | 2 | 6 | 4 | 9 | 10 | 11 | 6 | 8 | 5.954545454545454 | 5.95 | Michelle Damons | 6.785714285714286 | 101 |  | 26 | Phindile Ndhlovu | 127
[NAME] | EXNB189 | [NAME] | 3 | 8 | 5 |  | 5 | 7 | 10 | 11 | 6 | 4 | 6 | 9 | 7 | 10 |  | 7 | 6 | 12 | 5 | 3 |  |  |  | 7 | 9 | 7 | 7.157894736842105 | [NAME] | 6.777777777777778 | 126 |  | 27 | [NAME] | 126
[NAME] | EXNM105 | [NAME] | 3 | 10 | 6 |  | 5 | 4 | 5 | 2 | 3 | 1 | 6 | 9 |  | 11 | 1 | 6 | 10 | 5 | 10 | 9 |  | 6 | 8 | 7 | 11 | 6.272727272727272 | 6.8 | [NAME] | 6.769230769230769 | 89 |  | 28 | [NAME] | 125
Nyadzawela [NAME] | ABNMAD3 | Marinda du Plessis | 6 | 7 | 5 | 1 | 4 | 8 | 5 | 6 | 15 |  | 6 | 9 | 9 |  |  | 8 | 8 | 8 | 11 | 7 | 5 | 9 | 11 | 12 | 11 | 7.772727272727272 | 8.25 | [NAME] | 6.117647058823529 | 110 |  | 29 | [NAME] | 124
Phindile Ndhlovu | ABPN476 | [NAME] | 3 | 6 | 4 |  | 3 | 2 | 2 | 5 | 3 | 2 | 3 | 7 | 6 | 7 | 1 | 2 | 8 | 8 | 11 | 10 |  | 5 | 8 | 9 | 12 | 5.521739130434782 | 5.904761904761905 | [NAME] | 6.1 | 125 |  | 30 | Lindiwe Maepa | 118
[NAME] | ABPMA7M | [NAME] | 1 |  |  |  |  | 3 | 3 | 3 | 3 | 1 | 3 | 1 |  | 10 | 5 | 2 | 8 | 9 | 11 | 9 |  | 5 | 10 | 7 | 16 | 5.789473684210527 | 6.117647058823529 | [NAME] | 6.05 | 124 |  | 31 | [NAME] | 117
[NAME] | ABRM956 | [NAME] | 2 | 9 | 12 |  | 7 | 8 | 9 | 8 | 12 | 7 | 13 | 17 | 11 | 13 |  | 8 | 10 | 13 | 9 | 14 | 5 |  |  | 14 | 7 | 9.904761904761905 | 10.31578947368421 | [NAME] | 5.95 | 131 |  | 32 | [NAME] | 116
Ranchia Nokayi | EXRN145 | Marinda du Plessis | 4 | 10 | 8 | 4 | 11 | 9 | 11 | 10 | 8 |  | 9 | 9 | 9 | 9 | 3 | 5 | 9 | 9 | 11 | 6 |  | 13 | 11 | 13 | 9 | 8.695652173913043 | 9.19047619047619 | [NAME] | 5.947368421052632 | 116 |  | 33 | [NAME] | 115
[NAME] | EXRC130 | Marinda du Plessis | 6 | 5 | 4 | 5 | 4 | 4 | 5 | 7 | 4 |  | 3 | 1 | 6 | 5 | 3 | 5 | 2 | 5 | 4 | 4 |  | 9 | 4 | 1 | 9 | 4.565217391304348 | 4.619047619047619 | Phindile Ndhlovu | 5.904761904761905 | 127 |  | 34 | [NAME] | 110
[NAME] | EXRK111 | Marinda du Plessis | 1 | 5 | 3 | 5 | 4 | 2 | 5 |  | 4 |  | 3 | 5 | 3 | 3 | 6 | 4 | 3 | 3 | 2 | 3 |  |  | 2 | 4 | 2 | 3.428571428571428 | 3.210526315789474 | Lindiwe Maepa | 5.9 | 118 |  | 35 | [NAME] | 108
[NAME] | ABRS621 | [NAME] | 4 | 11 | 8 | 4 | 7 | 6 | 8 | 6 | 4 |  | 4 | 5 |  | 7 |  | 6 | 4 | 7 | 9 | 8 | 5 | 9 | 11 | 13 | 12 | 7.181818181818182 | 7.45 | [NAME] | 5.684210526315789 | 117 |  | 36 | [NAME] | 105
[NAME] | ABSW334 | Marinda du Plessis |  | 3 |  | 2 | 3 | 1 |  |  | 3 |  | 3 | 6 | 9 | 1 | 4 | 2 | 4 | 3 | 11 |  |  | 11 |  |  |  | 4.4 | 4.615384615384615 | [NAME] | 5.6 | 115 |  | 37 | Michelle Damons | 101
Sibusiso Sibeko | ABSSA3W | 0 | 4 | 10 | 9 | 4 | 9 | 6 | 5 | 5 | 5 |  | 6 | 6 | 7 | 4 |  | 6 | 7 | 6 | 10 | 6 | 6 | 9 | 13 |  |  | 6.809523809523809 | 7 | [NAME] | 5.25 | 108 |  | 38 | [NAME] | 89
[NAME] | EXSK133 | [NAME] |  |  |  |  | 5 | 3 | 5 | 7 | 6 |  | 6 | 8 | 8 | 5 | 4 | 2 | 6 | 8 | 10 | 9 |  | 6 | 8 | 9 | 11 | 6.631578947368421 | 6.777777777777778 | [NAME] | 4.882352941176471 | 83 |  | 39 | [NAME] | 84
[NAME] | EXSF123 | [NAME] | 4 | 5 | 3 |  | 5 | 2 |  | 2 | 4 | 2 | 3 | 5 | 6 | 6 | 1 | 4 | 4 | 8 | 9 | 6 |  | 5 | 10 | 7 | 14 | 5.227272727272728 | 5.6 | [NAME] | 4.619047619047619 | 105 |  | 40 | [NAME] | 83
[NAME] | EXTM596 | [NAME] | 3 | 9 | 8 |  |  | 6 | 7 | 8 | 5 |  | 10 | 7 | 8 | 9 |  | 1 | 9 | 10 | 11 | 11 | 4 | 10 | 8 | 12 | 8 | 7.809523809523809 | 8 | [NAME] | 4.615384615384615 | 66 |  | 41 | [NAME] | 79
[NAME] | ABTR217 | [NAME] | 5 | 11 | 9 | 4 |  |  |  | 10 | 6 |  | 8 | 9 | 6 | 10 |  | 5 | 6 | 7 | 8 | 7 | 5 | 10 | 11 | 11 | 10 | 7.9 | 8.277777777777779 | [NAME] | 4.315789473684211 | 84 |  | 42 | [NAME] | 72
[NAME] | EXZW105 | [NAME] | 5 | 12 | 12 | 6 | 8 | 8 | 5 | 10 | 3 |  | 8 | 6 | 9 | 9 |  | 5 | 8 | 12 | 9 | 7 | 6 | 10 | 11 | 13 | 12 | 8.434782608695652 | 8.666666666666666 | [NAME] | 3.210526315789474 | 72 |  | 43 | [NAME] | 66
Average |  |  | 4.210526315789473 | 8.552631578947368 | 6.974358974358974 | 3.85 | 6.428571428571429 | 5.641025641025641 | 6.147058823529412 | 6.825 | 6.619047619047619 | 3.315789473684211 | 6.285714285714286 | 7.146341463414634 | 7.526315789473684 | 7.357142857142857 | 2.6 | 4.72972972972973 | 7.210526315789473 | 7.743589743589744 | 8.317073170731707 | 7.552631578947368 | 5.043478260869565 | 8.405405405405405 | 8.72972972972973 | 9.972972972972974 | 10.76315789473684 | 6.717912762128086 | 7.292311967554683
 |  |  | 4 | 8 | 6 | 3 | 6 | 5 | 6 | 6 | 6 | 3 | 6 | 7 | 7 | 7 | 2 | 4 | 7 | 7 | 8 | 7 | 5 | 8 | 8 | 9 | 10 | 6 | 7
Ab number | Team Leader
EXSS139 | [NAME]
EXKM193 | [NAME]
ABLP420 | [NAME]
ABBT137 | [NAME]
EXMT148 | [NAME]
ABNMADZ | [NAME]
ABRS621 | [NAME]
ABDV180 | [NAME]
ABTR217 | [NAME]
EXAM322 | [NAME]
EXZW105 | [NAME]
EXNP145 | [NAME]
EXEM221 | [NAME]
EXTM596 | [NAME]
ABMMBAO | [NAME]
ABKM782 | [NAME]
EXGM103 | [NAME]
[NAME] | [NAME]
EXLL119 | [NAME]
EXMK126 | [NAME]
ABRM956 | [NAME]
EXNK128 | [NAME]
EXIL107 | [NAME]
EXDM277 | [NAME]
EXGN124 | [NAME]
EXNB189 | [NAME]
EXLN222 | [NAME]
EXSK133 | [NAME]
ABMD419 | [NAME]
ABCW433 | [NAME]
ABPN476 | [NAME]
ABFM329 | [NAME]
ABMN629 | [NAME]
EXNM105 | [NAME]
ABFH099 | [NAME]
ABMMBKY | [NAME]
EXSF123 | [NAME]
ABPMA7M | [NAME]
EXMM922 | [NAME]
EXGM138 | [NAME]
EXAT130 | Marinda du Plessis
EXNS241 | Marinda du Plessis
ABNMAD3 | Marinda du Plessis
ABCMA2K | Marinda du Plessis
ABSW334 | Marinda du Plessis
EXBR103 | Marinda du Plessis
EXRS129 | Marinda du Plessis
EXRK111 | Marinda du Plessis
ABMH452 | Marinda du Plessis
EXRN145 | Marinda du Plessis
EXGM232 | Marinda du Plessis
EXNB190 | Marinda du Plessis
EXFC119 | Marinda du Plessis
EXRC130 | Marinda du Plessis