Spreadsheet: 275372d1383491036-formula-that-counts-unique-values-within-a-criteria-gr-new
Sheet: Sheet1

 |  |  | Customer Code | Item Code | Jan 2013 sales
 |  |  | 622 | 105301 | 0
 |  |  | 622 | 105301 | 49.32
 |  |  | 622 | 105302 | 103.68
 |  |  | 622 | 105302 | 311.04
 |  |  | 622 | 5400 | 39.48
 |  |  | 622 | 5927 | 39.48
 |  |  | 622 | 5939 | 39.48
 |  |  | 622 | 5952 | 0
 |  |  | 622 | 5400 | 276.36
 |  |  | 622 | 5927 | 197.4
 |  |  | 622 | 5939 | 236.88
 |  |  | 622 | 5952 | 236.88
 |  |  | 622 | 70678 | -181.2
 |  |  | 622 | 70679 | 0
 |  |  | 622 | 70679 | 0
 |  |  | 622 | 149377 | 0
 |  |  | 622 | 149377 | 0
 |  |  | 622 | 149617 | 0
 |  |  | 622 | 149618 | 0
 |  |  | 622 | 149619 | 148
 |  |  | 622 | 155911 | 0
 |  |  | 622 | 155912 | 0
 |  |  | 622 | 162842 | 0
 |  |  | 622 | 162843 | 0
 |  |  | 622 | 149617 | 0
 |  |  | 622 | 149618 | 88.8
 |  |  | 622 | 149619 | 88.8
 |  |  | 622 | 162842 | 0
 |  |  | 622 | 162843 | 0
 |  |  | 622 | 152381 | 554.4
 |  |  | 622 | 152381 | 79.2
 |  |  | 622 | 135442 | 0
 |  |  | 622 | 135443 | 0
 |  |  | 622 | 135442 | 201.6
 |  |  | 622 | 135443 | 144
 |  |  | 622 | 138434 | 251.52
 |  |  | 622 | 143739 | 0
 |  |  | 622 | 154250 | 0
 |  |  | 622 | 156003 | 0
 |  |  | 622 | 138434 | 98.25
 |  |  | 622 | 143739 | 0
 |  |  | 622 | 154250 | 98.25
 |  |  | 622 | 156003 | 0
 |  |  | 622 | 139855 | 666.7
 |  |  | 622 | 161415 | 0
 |  |  | 622 | 139855 | 0
 |  |  | 622 | 161415 | 0
 |  |  | 622 | 93928 | 46.08
 |  |  | 622 | 35905 | 0
 |  |  | 622 | 35906 | 0
 |  |  | 622 | 35907 | 0
 |  |  | 622 | 35905 | 0
 |  |  | 622 | 35906 | 0
 |  |  | 622 | 35907 | 0
 |  |  | 622 | 35910 | 0
 |  |  | 622 | 35911 | 43.05
 |  |  | 622 | 35910 | 0
 |  |  | 622 | 35911 | 0
 |  |  | 622 | 10227 | 0
 |  |  | 622 | 10227 | 128.16
 |  |  | 622 | 102322634 | 0
 |  |  | 622 | 102322634 | 60.48
 |  |  | 622 | 13722 | 116.4
 |  |  | 622 | 13722 | 58.2
 |  |  | 622 | 12234 | 0
 |  |  | 622 | 12234 | 512.64
 |  |  | 622 | 10229 | 0
 |  |  | 622 | 10229 | 176.31
 |  |  | 622 | 10237 | 0
 |  |  | 622 | 10238 | 0
 |  |  | 622 | 10237 | 1452.3
 |  |  | 622 | 10238 | 1555.2
 |  |  | 622 | 102857 | 37.6
 |  |  | 622 | 82823 | 35.28
 |  |  | 622 | 102857 | 564
 |  |  | 622 | 82823 | 282.24
 |  |  | 622 | 142260 | 144.48
 |  |  | 622 | 142261 | 75.84
 |  |  | 622 | 142260 | 0
 |  |  | 622 | 142261 | 227.52
 |  |  | 622 | 142872 | 0
 |  |  | 622 | 142872 | 168.12
 |  |  | 622 | 102180 | 0
 |  |  | 622 | 102180 | 0
 |  |  | 622 | 104165 | 0
 |  |  | 622 | 82657 | 0
 |  |  | 622 | 82658 | 0
 |  |  | 622 | 104165 | 14.88
 |  |  | 622 | 82657 | -29.76
 |  |  | 622 | 82658 | 74.4
 |  |  | 622 | 155915 | 0
 |  |  | 622 | 155916 | 0
 |  |  | 622 | 155917 | 0
 |  |  | 622 | 155915 | 0
 |  |  | 622 | 155916 | 0
 |  |  | 622 | 155917 | 0
 |  |  | 622 | 114496 | 135.3
 |  |  | 622 | 83781 | 344.4
 |  |  | 622 | 83782 | 135.3
 |  |  | 622 | 114496 | 184.5
 |  |  | 622 | 83781 | 627.3000000000001
 |  |  | 622 | 83782 | 246
 |  |  | 622 | 150831 | 369
 |  |  | 622 | 150831 | 442.8
 |  |  | 622 | 155918 | 0
 |  |  | 622 | 155918 | 0
 |  |  | 622 | 148081 | 0
 |  |  | 622 | 148082 | 253.68
 |  |  | 622 | 82204 | 0
 |  |  | 622 | 148081 | 0
 |  |  | 622 | 148082 | 253.68
 |  |  | 622 | 82204 | 0
 |  |  | 622 | 148080 | 0
 |  |  | 622 | 148080 | 0
 |  |  | 622 | 82280 | 104.64
 |  |  | 622 | 82281 | 0
 |  |  | 622 | 105473 | 0
 |  |  | 622 | 82280 | 209.28
 |  |  | 622 | 82281 | 104.64
 |  |  | 622 | 105473 | 0
 |  |  | 622 | 147012 | 0
 |  |  | 622 | 147013 | 0
 |  |  | 622 | 82089 | 115.55
 |  |  | 622 | 82090 | 46.22
 |  |  | 622 | 147012 | 115.55
 |  |  | 622 | 147013 | 46.22
 |  |  | 622 | 82089 | 415.98
 |  |  | 622 | 82090 | 161.77
 |  |  | 622 | 80641 | 216.6
 |  |  | 622 | 80641 | 180.5
 |  |  | 622 | 81803 | 123
 |  |  | 622 | 81803 | 1230
 |  |  | 622 | 522022635 | 0
 |  |  | 622 | 522672635 | 46.53
 |  |  | 622 | 522022635 | 325.71
 |  |  | 622 | 522672635 | 93.06
 |  |  | 622 | 161492 | 0
 |  |  | 622 | 161492 | 0
 |  |  | 622 | 154562 | 0
 |  |  | 622 | 45090 | 0
 |  |  | 622 | 45091 | 0
 |  |  | 622 | 45092 | 176.4
 |  |  | 622 | 45112 | 0
 |  |  | 622 | 45113 | 0
 |  |  | 622 | 45117 | 55.43
 |  |  | 622 | 45118 | 0
 |  |  | 622 | 67359 | 0
 |  |  | 622 | 67360 | 0
 |  |  | 622 | 154562 | 0
 |  |  | 622 | 45090 | 83
 |  |  | 622 | 45091 | 189
 |  |  | 622 | 45092 | 441
 |  |  | 622 | 45112 | 45.79
 |  |  | 622 | 45113 | 7.17
 |  |  | 622 | 45117 | 166.29
 |  |  | 622 | 45118 | 14.46
 |  |  | 622 | 67359 | 101.22
 |  |  | 622 | 67360 | 45.79
 |  |  | 622 | 81797 | 59.56
 |  |  | 622 | 81797 | 208.46
 |  |  | 622 | 81820 | 17.89
 |  |  | 622 | 81820 | 71.56
 |  |  | 622 | 30450 | 74.48
 |  |  | 622 | 30450 | 74.48
 |  |  | 622 | 304167901 | 35.46
 |  |  | 622 | 304167901 | 141.84
 |  |  | 622 | 161231 | 0
 |  |  | 622 | 161231 | 0
 |  |  | 622 | 161232 | 0
 |  |  | 622 | 161232 | 0
 |  |  | 622 | 139127 | 30.72
 |  |  | 622 | 139127 | 61.44
 |  |  | 622 | 80809 | 58.32
 |  |  | 622 | 80809 | 379.08
 |  |  | 622 | 80719 | 106.8
 |  |  | 622 | 80719 | 747.6
 |  |  | 622 | 81500 | 0
 |  |  | 622 | 81500 | 0
 |  |  | 622 | 81501 | 51.84
 |  |  | 622 | 81501 | 362.88
 |  |  | 622 | 81550 | 53.64
 |  |  | 622 | 81550 | 482.76
 |  |  | 622 | 150006 | 0
 |  |  | 622 | 150006 | 239.4
 |  |  | 622 | 67940 | 64.8
 |  |  | 622 | 67940 | 291.6
 |  |  | 622 | 67939 | 110.4
 |  |  | 622 | 67939 | 414
 |  |  | 622 | 67938 | 148.68
 |  |  | 622 | 67938 | 693.84
 |  |  | 622 | 67666 | 0
 |  |  | 622 | 67666 | 54.24
 |  |  | 622 | 67667 | 0
 |  |  | 622 | 67667 | 50.88
 |  |  | 622 | 67799 | 0
 |  |  | 622 | 67799 | 24.12
 |  |  | 622 | 137045 | 0
 |  |  | 622 | 69359 | 0
 |  |  | 622 | 137045 | 0
 |  |  | 622 | 69359 | 51.84
 |  |  | 622 | 10296 | 58.32
 |  |  | 622 | 10296 | 116.64
 |  |  | 622 | 67796 | 0
 |  |  | 622 | 68899 | 0
 |  |  | 622 | 69361 | 0
 |  |  | 622 | 67796 | 38.88
 |  |  | 622 | 68899 | 0
 |  |  | 622 | 139149 | 0
 |  |  | 622 | 139149 | 0
 |  |  | 622 | 35879 | 0
 |  |  | 622 | 35880 | 0
 |  |  | 622 | 35882 | 0
 |  |  | 622 | 35883 | 0
 |  |  | 622 | 35885 | 0
 |  |  | 622 | 35887 | 0
 |  |  | 622 | 35879 | 40.64
 |  |  | 622 | 35880 | 25.4
 |  |  | 622 | 35882 | 0
 |  |  | 622 | 35883 | 25.4
 |  |  | 622 | 35885 | 25.4
 |  |  | 622 | 35887 | 0
 |  |  | 622 | 35896 | 0
 |  |  | 622 | 35897 | 0
 |  |  | 622 | 35896 | 0
 |  |  | 622 | 35897 | 0
 |  |  | 622 | 161617 | 0
 |  |  | 622 | 161634 | 0
 |  |  | 622 | 161617 | 0
 |  |  | 622 | 161634 | 0
 |  |  | 622 | 113824 | 0
 |  |  | 622 | 113825 | 0
 |  |  | 622 | 113826 | 0
 |  |  | 622 | 113827 | 0
 |  |  | 622 | 113824 | 0
 |  |  | 622 | 113825 | 0
 |  |  | 622 | 113826 | 0
 |  |  | 622 | 113827 | 0
 |  |  | 622 | 142125 | 0
 |  |  | 622 | 142126 | 0
 |  |  | 622 | 142125 | 17.7
 |  |  | 622 | 142126 | 0
 |  |  | 622 | 142106 | 0
 |  |  | 622 | 142123 | 0
 |  |  | 622 | 142124 | 0
 |  |  | 622 | 142106 | 29.5
 |  |  | 622 | 142123 | 29.5
 |  |  | 622 | 142124 | 29.5
 |  |  | 622 | 149975 | 177.12
 |  |  | 622 | 149976 | 0
 |  |  | 622 | 149975 | 0
 |  |  | 622 | 149976 | 0
 |  |  | 622 | 124442 | -26.52
 |  |  | 622 | 124443 | 0
 |  |  | 622 | 124444 | 0
 |  |  | 622 | 124442 | 0
 |  |  | 622 | 124443 | 0
 |  |  | 622 | 124444 | 0
 |  |  | 622 | 153027 | 115.05
 |  |  | 622 | 153029 | 79.65
 |  |  | 622 | 153030 | 79.65
 |  |  | 622 | 153027 | 256.65
 |  |  | 622 | 153029 | 256.65
 |  |  | 622 | 153030 | 221.25
 |  |  | 622 | 152987 | 36.9
 |  |  | 622 | 152988 | 36.9
 |  |  | 622 | 152989 | 36.9
 |  |  | 622 | 152990 | 36.9
 |  |  | 622 | 152987 | 147.6
 |  |  | 622 | 152988 | 147.6
 |  |  | 622 | 152989 | 147.6
 |  |  | 622 | 152990 | 147.6
 |  |  | 622 | 159011 | 0
 |  |  | 622 | 159012 | 0
 |  |  | 622 | 10634 | 0
 |  |  | 622 | 10634 | 0
 |  |  | 622 | 120379 | 24.36
 |  |  | 622 | 120379 | 170.52
 |  |  | 622 | 10266 | 0
 |  |  | 622 | 10269 | -50.7
 |  |  | 622 | 10276 | 0
 |  |  | 622 | 10265 | 152.1
 |  |  | 622 | 10266 | 0
 |  |  | 622 | 10269 | 0
 |  |  | 622 | 10276 | 0