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

 |  |  | Saturday |  |  |  |  |  | Saturday |  |  |  |  |  | Saturday |  |  |  |  |  | Ranking |  |  |  | Agent Ranking on Sales
Agent Name | AB Number | Team Leader | 2010-07-17 00:00:00 | 2010-07-16 00:00:00 | 2010-07-15 00:00:00 | 2010-07-14 00:00:00 | 2010-07-13 00:00:00 | 2010-07-12 00:00:00 | 2010-07-10 00:00:00 | 2010-07-09 00:00:00 | 2010-07-08 00:00:00 | 2010-07-07 00:00:00 | 2010-07-06 00:00:00 | 2010-07-05 00:00:00 | 2010-07-03 00:00:00 | 2010-07-02 00:00:00 | 2010-07-01 00:00:00 | Monthly Average | Monthly average (Excl Saturdays) | Consultant | Monthly Average (Excl Saturday) | Sales |  |  | # | Consultant | Sales
Hope Seemise | EXIS123 | 0 |  |  |  | 2 | 7 | 5 |  | 2 | 2 | 7 | 4 |  |  |  |  | 4.142857142857143 | 4.142857142857143 | [NAME] | 8.222222222222221 | 94 |  |  | 1 | Kamo C Maripane | 101
[NAME] | EXAM322 | [NAME] | 4 | 5 | 4 | 6 | 5 | 6 |  | 4 | 4 | 4 | 3 | 5 |  | 4 | 3 | 4.384615384615385 | 4.4 | Nyadzawela [NAME] | 8.222222222222221 | 87 |  |  | 2 | [NAME] | 99
[NAME] | ABLP420 | [NAME] | 3 | 7 | 11 | 8 | 8 | 10 |  | 8 | 7 | 8 | 10 | 5 |  | 5 | 9 | 7.615384615384615 | 7.8 | Kamo C Maripane | 7.9 | 101 |  |  | 3 | [NAME] | 94
[NAME] | ABBT137 | [NAME] |  | 5 |  |  |  | 3 |  | 4 | 2 | 8 | 9 | 7 |  | 6 | 6 | 5.555555555555555 | 5.625 | [NAME] | 7.8 | 99 |  |  | 4 | [NAME] | 89
Bridget Mohale | [NAME] | [NAME] |  | 9 | 9 |  |  |  |  | 1 | 13 | 5 | 8 | 6 | 2 | 11 | 10 | 7.4 | 7.714285714285714 | Bridget Mohale | 7.714285714285714 | 74 |  |  | 5 | [NAME] | 89
[NAME] | ABCW433 | [NAME] | 4 | 2 | 4 | 2 | 5 | 3 |  |  |  |  | 13 | 3 |  | 5 | 7 | 4.8 | 5.428571428571429 | [NAME] | 7.4 | 37 |  |  | 6 | Innocentia Letsoalo | 88
[NAME] | EXDM277 | [NAME] |  | 9 | 8 | 4 | 9 | 6 | 1 | 3 | 6 | 5 | 8 | 6 | 4 | 6 | 9 | 6 | 6.2 | [NAME] | 7.375 | 85 |  |  | 7 | Nyadzawela [NAME] | 87
[NAME] | ABDV180 | [NAME] | 3 | 8 | 9 | 6 | 8 | 10 |  | 7 | 6 | 8 | 11 |  |  | 6 | 12 | 7.833333333333333 | 8.222222222222221 | [NAME] | 7.1 | 89 |  |  | 8 | [NAME] | 85
Danisile [NAME] | EXDM318 | 0 |  | 1 |  | 1 | 3 | 3 |  | 1 |  |  |  |  |  |  |  | 1.8 | 2 | [NAME] | 7.1 | 89 |  |  | 9 | [NAME] | 84
[NAME] | EXNB190 | Marinda du Plessis |  |  |  |  |  | 1 |  |  |  | 6 | 6 | 2 |  | 5 | 3 | 3.833333333333333 | 3.833333333333333 | [NAME] | 6.9 | 81 |  |  | 10 | [NAME] | 84
[NAME] | EXEM221 | [NAME] | 3 | 6 | 9 | 6 | 5 | 13 |  | 7 | 5 | 9 | 5 | 8 |  | 6 | 7 | 6.846153846153846 | 7.1 | Ranchia Nokayi | 6.9 | 83 |  |  | 11 | Ranchia Nokayi | 83
[NAME] | ABFH099 | [NAME] |  | 3 | 2 | 2 |  | 1 |  | 1 |  | 4 | 6 | 6 |  | 4 | 8 | 3.7 | 4 | Innocentia Letsoalo | 6.7 | 88 |  |  | 12 | [NAME] | 81
Glodean ([NAME]) Mekwa | EXGM103 | [NAME] |  | 1 | 3 | 4 | 1 | 5 |  | 2 | 4 | 10 | 5 | 5 | 1 | 5 | 4 | 3.846153846153846 | 4.5 | [NAME] | 6.6 | 84 |  |  | 13 | [NAME] | 80
[NAME] | EXGM232 | Marinda du Plessis | 1 | 2 | 8 | 5 | 2 | 6 |  | 6 | 4 | 5 | 8 | 6 |  | 4 | 7 | 4.923076923076923 | 5.3 | [NAME] | 6.3 | 79 |  |  | 14 | [NAME] | 79
Innocentia Letsoalo | EXIL107 | [NAME] | 2 | 6 | 10 | 3 | 8 | 4 |  | 4 | 6 | 8 | 9 | 9 | 3 | 8 | 8 | 6.285714285714286 | 6.7 | [NAME] | 6.2 | 84 |  |  | 15 | Sibusiso Sibeko | 75
Kamo C Maripane | ABKM964 | 0 | 6 | 7 | 9 | 6 | 8 | 10 |  | 6 | 8 | 6 | 9 | 8 |  | 9 | 9 | 7.769230769230769 | 7.9 | [NAME] | 6.1 | 67 |  |  | 16 | Bridget Mohale | 74
[NAME] | ABKM782 | [NAME] |  | 2 | 4 | 3 | 8 | 9 |  | 4 | 4 | 3 | 7 | 6 |  | 11 | 6 | 5.583333333333333 | 6.1 | [NAME] | 6.1 | 80 |  |  | 17 | [NAME] | 71
[NAME] | EXLN222 | [NAME] |  |  |  |  |  |  |  | 1 | 9 | 10 | 9 | 8 |  |  |  | 7.4 | 7.4 | [NAME] | 6 | 71 |  |  | 18 | [NAME] | 71
Lindiwe Maepa | ABFM329 | [NAME] | 1 | 3 | 1 | 2 | 1 | 2 |  | 3 | 4 | 2 | 4 | 2 |  | 6 | 4 | 2.692307692307693 | 3 | [NAME] | 5.8 | 68 |  |  | 19 | [NAME] | 68
[NAME] | EXGM138 | [NAME] |  |  | 1 | 4 | 4 | 3 |  | 5 | 5 | 4 | 5 | 7 |  | 8 | 8 | 4.909090909090909 | 5.3 | Sibusiso Sibeko | 5.7 | 75 |  |  | 20 | Musiwalo [NAME] | 68
Magauta Petlele | EXMP221 | 0 |  |  | 1 | 2 | 3 | 2 |  | 2 | 3 | 4 | 2 |  |  |  |  | 2.375 | 2.571428571428572 | [NAME] | 5.666666666666667 | 65 |  |  | 21 | [NAME] | 67
[NAME] | ABMH452 | Marinda du Plessis |  | 3 | 5 | 4 | 3 | 4 |  | 6 | 4 | 9 | 6 | 10 | 2 | 9 | 3 | 5.230769230769231 | 5.8 | [NAME] | 5.625 | 50 |  |  | 22 | [NAME] | 65
[NAME] | EXNS298 | 0 |  |  | 1 | 3 | 3 | 4 |  | 1 |  | 1 | 2 |  |  |  |  | 2.142857142857143 | 2.333333333333333 | Musiwalo [NAME] | 5.6 | 68 |  |  | 23 | [NAME] | 64
Michelle Damons | ABMD419 | [NAME] |  | 2 | 7 | 3 |  | 3 |  | 5 | 4 | 6 | 10 | 4 |  | 5 | 4 | 4.818181818181818 | 4.888888888888889 | [NAME] | 5.5 | 71 |  |  | 24 | [NAME] | 60
[NAME] | EXMM922 | [NAME] | 2 | 2 | 5 |  | 4 | 3 |  | 2 | 3 | 3 | 2 | 5 |  | 5 | 5 | 3.416666666666667 | 3.555555555555555 | [NAME] | 5.428571428571429 | 48 |  |  | 25 | [NAME] | 57
[NAME] | ABMMBKY | [NAME] | 2 | 6 | 6 | 3 | 5 |  |  | 2 | 8 | 3 | 9 | 9 |  | 6 | 6 | 5.416666666666667 | 5.666666666666667 | [NAME] | 5.3 | 64 |  |  | 26 | [NAME] | 54
[NAME] | ABMMBAO | [NAME] |  | 3 | 8 | 5 | 6 | 5 |  | 6 | 9 | 11 | 7 | 10 | 1 | 7 | 3 | 6.230769230769231 | 6.9 | [NAME] | 5.3 | 54 |  |  | 27 | Michelle Damons | 53
Musiwalo [NAME] | ABMT654 | 0 | 1 | 8 | 3 | 5 | 5 | 5 |  | 6 | 2 | 7 | 7 | 6 |  | 6 | 7 | 5.230769230769231 | 5.6 | Michelle Damons | 4.888888888888889 | 53 |  |  | 28 | [NAME] | 53
[NAME] | ABNK365 | 0 |  | 3 | 8 | 4 | 6 | 8 |  | 6 | 4 | 9 | 7 | 12 | 7 | 9 | 6 | 6.846153846153846 | 7.1 | [NAME] | 4.875 | 53 |  |  | 29 | [NAME] | 52
[NAME] | ABNMADZ | [NAME] | 2 | 2 | 4 | 7 | 5 | 3 |  | 5 | 5 | 1 | 4 | 3 |  | 4 | 7 | 4 | 4.4 | [NAME] | 4.8 | 60 |  |  | 30 | [NAME] | 50
[NAME] | EXNB189 | [NAME] | 2 | 2 | 6 | 8 | 5 | 8 |  | 3 | 4 | 10 | 8 | 7 | 1 | 2 | 5 | 5.071428571428571 | 6 | [NAME] | 4.555555555555555 | 45 |  |  | 31 | Glodean ([NAME]) Mekwa | 50
[NAME] | EXNM743 | 0 |  |  | 1 | 2 | 3 | 3 |  | 1 | 1 | 1 | 1 |  |  |  |  | 1.625 | 1.714285714285714 | Glodean ([NAME]) Mekwa | 4.5 | 50 |  |  | 32 | [NAME] | 50
[NAME] | EXNM105 | [NAME] | 3 | 3 | 1 | 2 | 6 | 1 |  | 2 | 3 | 6 | 4 | 3 |  | 4 | 5 | 3.307692307692307 | 3.6 | [NAME] | 4.4 | 57 |  |  | 33 | [NAME] | 48
[NAME] | EXNK127 | 0 |  | 2 | 1 | 2 | 5 | 3 |  | 2 | 2 | 1 | 3 |  |  |  |  | 2.333333333333333 | 2.571428571428572 | [NAME] | 4.4 | 52 |  |  | 34 | [NAME] | 48
Nyadzawela [NAME] | ABNMAD3 | Marinda du Plessis |  | 4 | 6 | 2 | 6 | 11 | 1 |  | 6 | 15 | 8 | 11 | 2 | 8 | 7 | 6.692307692307693 | 8.222222222222221 | Phindile Ndhlovu | 4.375 | 43 |  |  | 35 | [NAME] | 45
Phindile Ndhlovu | ABPN476 | [NAME] | 2 | 4 | 2 | 1 | 5 | 2 |  |  |  | 5 | 2 | 6 |  | 7 | 7 | 3.909090909090909 | 4.375 | Hope Seemise | 4.142857142857143 | 29 |  |  | 36 | [NAME] | 43
[NAME] | ABPMA7M | [NAME] |  | 3 | 4 | 2 | 5 | 1 |  | 2 | 7 | 8 | 5 | 1 |  | 8 | 2 | 4 | 4.1 | [NAME] | 4.1 | 48 |  |  | 37 | Phindile Ndhlovu | 43
[NAME] | ABRM956 | [NAME] | 4 | 9 | 8 | 4 |  |  |  | 7 | 5 | 7 | 9 | 11 | 5 | 8 | 8 | 7.083333333333333 | 7.375 | [NAME] | 4.1 | 50 |  |  | 38 | [NAME] | 41
Ranchia Nokayi | EXRN145 | Marinda du Plessis |  | 4 | 8 | 5 | 7 | 9 |  | 5 | 5 | 6 | 8 | 8 | 2 | 9 | 7 | 6.384615384615385 | 6.9 | [NAME] | 4 | 37 |  |  | 39 | [NAME] | 37
[NAME] | EXRC130 | Marinda du Plessis |  | 1 |  | 3 | 4 | 5 |  | 3 |  | 2 | 1 | 7 | 3 | 13 | 3 | 4.090909090909091 | 4.555555555555555 | [NAME] | 3.833333333333333 | 23 |  |  | 40 | [NAME] | 37
[NAME] | EXRK111 | Marinda du Plessis | 1 | 8 | 5 | 6 | 6 |  |  | 1 | 3 | 5 | 5 | 6 |  | 7 |  | 4.818181818181818 | 4.875 | [NAME] | 3.6 | 43 |  |  | 41 | Lindiwe Maepa | 35
[NAME] | ABRS621 | [NAME] | 5 | 6 | 5 | 4 | 7 | 9 |  | 4 | 4 | 6 | 3 | 7 |  | 5 | 6 | 5.461538461538462 | 5.5 | [NAME] | 3.555555555555555 | 41 |  |  | 42 | Hope Seemise | 29
[NAME] | ABSW334 | Marinda du Plessis | 1 |  |  |  |  |  |  |  | 1 |  | 1 |  |  | 4 | 4 | 2.2 | 2.5 | Sivuyile Ngovela | 3.142857142857143 | 22 |  |  | 43 | [NAME] | 23
Sibusiso Sibeko | ABSSA3W | 0 | 4 | 8 | 6 | 4 | 8 | 8 |  | 5 | 3 | 6 | 5 | 7 |  | 5 | 6 | 5.769230769230769 | 5.7 | Lindiwe Maepa | 3 | 35 |  |  | 44 | Sivuyile Ngovela | 22
Sivuyile Ngovela | EXSN321 | 0 |  |  |  | 2 | 7 | 4 |  | 1 | 1 | 5 | 2 |  |  |  |  | 3.142857142857143 | 3.142857142857143 | Magauta Petlele | 2.571428571428572 | 19 |  |  | 45 | [NAME] | 21
[NAME] | EXSK133 | [NAME] | 4 | 3 | 2 | 4 | 4 | 4 |  | 1 | 2 | 5 | 6 | 5 |  | 5 | 5 | 3.846153846153846 | 4.1 | [NAME] | 2.571428571428572 | 21 |  |  | 46 | Magauta Petlele | 19
[NAME] | EXSF123 | [NAME] | 3 | 4 | 5 | 3 | 6 | 2 |  | 1 | 5 | 3 | 10 | 6 |  | 6 | 6 | 4.615384615384615 | 4.8 | [NAME] | 2.5 | 11 |  |  | 47 | [NAME] | 15
[NAME] | EXTM596 | [NAME] | 4 | 5 | 7 | 5 | 6 | 8 |  | 5 | 5 | 6 | 7 | 6 |  | 7 | 8 | 6.076923076923077 | 6.3 | [NAME] | 2.333333333333333 | 15 |  |  | 48 | [NAME] | 13
[NAME] | ABTR217 | [NAME] | 4 | 7 | 7 | 6 | 5 | 8 |  | 5 | 8 | 8 | 1 | 10 |  | 7 | 8 | 6.461538461538462 | 6.6 | Danisile [NAME] | 2 | 9 |  |  | 49 | [NAME] | 11
[NAME] | EXZH108 | 0 |  |  | 1 | 1 | 1 | 1 |  | 1 |  | 2 | 2 |  |  |  |  | 1.285714285714286 | 1.333333333333333 | [NAME] | 1.714285714285714 | 13 |  |  | 50 | Danisile [NAME] | 9
[NAME] | EXZW105 | [NAME] | 4 | 8 | 7 | 5 | 6 | 9 |  | 6 | 8 | 6 | 3 | 6 |  | 5 | 7 | 6.153846153846154 | 6.1 | [NAME] | 1.333333333333333 | 9 |  |  | 51 | [NAME] | 9
Average |  |  | 2.884615384615385 | 4.536585365853658 | 5.162790697674419 | 3.8 | 5.209302325581396 | 5.177777777777778 | 1 | 3.58695652173913 | 4.744186046511628 | 5.8125 | 5.78 | 6.463414634146342 | 2.75 | 6.428571428571429 | 6.219512195121951 | 4.637080825172874 | 5.243466416081477
 |  |  | 2 | 4 | 5 | 3 | 5 | 5 | 1 | 3 | 4 | 5 | 5 | 6 | 2 | 6 | 6 | 4 | 5
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