Spreadsheet: 50448d1249910203-countifs-help-testdata
Sheet: data

Field_Sales_Manager | Brand_ID_(IBSRP2)_(UDC) | SumOfQuantity | SumOfSales_12_month | SumOfSales_3_month | DSI
[NAME] | xs123 | 80 | 4 | 2 | 7300 | 1
[NAME] | xs123 | 106 | 18 | 2 | 2149.444444444445 | 1
[NAME] | xs123 | 40 | 8 | 2 | 1825 | 1
[NAME] | xs123 | 60 | 19 | 6 | 1152.631578947368 | 1
[NAME] | xs123 | 43 | 14 | 2 | 1121.071428571429 | 1
[NAME] | xs123 | 73 | 27 | 8 | 986.8518518518518 | 1
[NAME] | xs123 | 71 | 28 | 10 | 925.5357142857142 | 1
[NAME] | xs123 | 120 | 48 | 10 | 912.5 | 1
[NAME] | xs123 | 84 | 34 | 2 | 901.7647058823529 | 1
[NAME] | xs123 | 55 | 25 | 6 | 803.0000000000001 | 1
[NAME] | [NAME] | 429 | 4 | 0 | 39146.25 | 1
[NAME] | [NAME] | 74 | 1 | 1 | 27010 | 1
[NAME] | [NAME] | 143 | 5 | 5 | 10439 | 1
[NAME] | [NAME] | 198 | 13 | 8 | 5559.230769230769 | 1
[NAME] | [NAME] | 49 | 4 | 0 | 4471.25 | 1
[NAME] | [NAME] | 183 | 18 | 0 | 3710.833333333333 | 1
Des McCluskey | [NAME] | 171 | 17 | 17 | 3671.470588235294 | 1
[NAME] | [NAME] | 57 | 0 | 0 | 9999
[NAME] | [NAME] | 108 | 0 | 0 | 9999
[NAME] | [NAME] | 165 | 0 | 0 | 9999
Des McCluskey | [NAME] | 36 | 1 | 1 | 13140 | 1
Des McCluskey | [NAME] | 84 | 4 | 4 | 7665 | 1
[NAME] | [NAME] | 19 | 1 | 1 | 6935 | 1
[NAME] | [NAME] | 19 | 1 | 1 | 6935 | 1
[NAME] | [NAME] | 38 | 5 | 0 | 2774 | 1
[NAME] | [NAME] | 76 | 12 | 6 | 2311.666666666667 | 1
[NAME] | [NAME] | 21 | 0 | 0 | 9999
[NAME] | [NAME] | 57 | 0 | 0 | 9999
[NAME] | [NAME] | 38 | 0 | 0 | 9999
[NAME] | [NAME] | 26 | 0 | 0 | 9999
[NAME] | gt300 | 18 | 1 | 0 | 6570 | 1
[NAME] | gt300 | 10 | 5 | 2 | 730 | 1
[NAME] | gt300 | 2 | 4 | 2 | 182.5 | 1
[NAME] | gt300 | 10 | 26 | 16 | 140.3846153846154 | 1
[NAME] | gt300 | 12 | 0 | 0 | 9999 | 1
[NAME] | gt300 | 9 | 0 | 0 | 1 | 1
[NAME] | gt300 | 2 | 0 | 0 | 9999 | 1
[NAME] | ftr17 | 52 | 31 | 10 | 612.258064516129 | 1
Des McCluskey | ftr17 | 64 | 41 | 14 | 569.7560975609756 | 1
[NAME] | ftr17 | 46 | 35 | 5 | 479.7142857142857 | 1
[NAME] | ftr17 | 126 | 101 | 49 | 455.3465346534654 | 1
Des McCluskey | ftr17 | 199 | 206 | 58 | 352.5970873786408 | 1
[NAME] | ftr17 | 42 | 47 | 17 | 326.1702127659574 | 1
[NAME] | ftr17 | 86 | 110 | 26 | 285.3636363636364 | 1
[NAME] | ftr17 | 71 | 100 | 8 | 259.15 | 1
[NAME] | ftr17 | 9 | 0 | 0 | 1 | 1
[NAME] | ftr17 | 5 | 0 | 0 | 1 | 1
[NAME] | 789 ttp | 25 | 1 | 0 | 9125 | 1
[NAME] | 789 ttp | 21 | 1 | 0 | 7665 | 1
[NAME] | 789 ttp | 15 | 1 | 1 | 5475 | 1
[NAME] | 789 ttp | 40 | 5 | 0 | 2920 | 1
[NAME] | 789 ttp | 15 | 0 | 0 | 1 | 1
[NAME] | 789 ttp | 15 | 0 | 0 | 9999 | 1
[NAME] | 789 ttp | 16 | 0 | 0 | 1 | 1
[NAME] | 789 ttp | 84 | 0 | 0 | 9999 | 1
[NAME] | 789 ttp | 32 | 0 | 0 | 1 | 1
Des McCluskey | 789 ttp | 8 | 0 | 0 | 9999 | 1
[NAME] | 789 ttp | 1 | 0 | 0 | 1 | 1
Des McCluskey | DDX1 | 199 | 206 | 58 | 352.5970873786408 | 1
[NAME] | DDX1 | 86 | 110 | 26 | 285.3636363636364 | 1
[NAME] | DDX1 | 4 | 21 | 2 | 69.52380952380952 | 1
[NAME] | spo17 | 107 | 4 | 0 | 9763.75 | 1
[NAME] | spo17 | 75 | 8 | 0 | 3421.875 | 1
[NAME] | spo17 | 100 | 15 | 2 | 2433.333333333333 | 1
[NAME] | spo17 | 61 | 11 | 2 | 2024.090909090909 | 1
Des McCluskey | spo17 | 29 | 0 | 0 | 9999 | 1
Des McCluskey | spo17 | 45 | 0 | 0 | 9999 | 1
[NAME] | spo17 | 49 | 0 | 0 | 9999 | 1
[NAME] | spo17 | 63 | 0 | 0 | 9999 | 1
[NAME] | spo17 | 50 | 0 | -1 | 9999 | 1
[NAME] | spo17 | 3 | 0 | 0 | 9999 | 1
[NAME] | spop5 | 143 | 5 | 3 | 10439 | 1
[NAME] | spop5 | 164 | 6 | 0 | 9976.666666666666 | 1
[NAME] | spop5 | 174 | 8 | 4 | 7938.75 | 1
Des McCluskey | spop5 | 103 | 11 | 0 | 3417.727272727273 | 1
[NAME] | spop5 | 127 | 23 | 1 | 2015.434782608696 | 1
[NAME] | spop5 | 196 | 49 | 12 | 1460 | 1
[NAME] | spop5 | 114 | 29 | 6 | 1434.827586206897 | 1
[NAME] | spop5 | 215 | 55 | 6 | 1426.818181818182 | 1
[NAME] | spop5 | 1 | 0 | 0 | 9999 | 1
[NAME] | spop5 | 1 | 0 | 0 | 1 | 1
[NAME] | 121hgh | 25 | 1 | 0 | 9125 | 1
[NAME] | 121hgh | 50 | 4 | 2 | 4562.5 | 1
[NAME] | 121hgh | 25 | 2 | 2 | 4562.5 | 1
[NAME] | 121hgh | 75 | 9 | 0 | 3041.666666666667 | 1
[NAME] | 121hgh | 25 | 0 | 0 | 1 | 1
[NAME] | ffp474 | 36 | 1 | 1 | 13140 | 1
[NAME] | ffp474 | 18 | 2 | 0 | 3285 | 1
Des McCluskey | ffp474 | 25 | 4 | 3 | 2281.25 | 1
[NAME] | ffp474 | 41 | 9 | 4 | 1662.777777777778 | 1
[NAME] | ffp474 | 15 | 4 | 1 | 1368.75 | 1
[NAME] | ffp474 | 6 | 2 | 0 | 1095 | 1
[NAME] | ffp474 | 19 | 8 | 2 | 866.875 | 1
[NAME] | ffp474 | 4 | 0 | 0 | 1 | 1
[NAME] | ffp474 | 10 | 0 | 0 | 9999 | 1
[NAME] | ffp474 | 30 | 0 | 0 | 1 | 1
[NAME] | ffp474 | 4 | 0 | 0 | 9999 | 1
[NAME] | ffp474 | 8 | 0 | 0 | 1 | 1
[NAME] | ffp474 | 14 | 0 | 0 | 9999 | 1
[NAME] | ffp474 | 1 | 0 | 0 | 9999 | 1
 |  |  |  |  |  | 1