Spreadsheet: 797016d1663671635-using-sumproduct-to-conditionally-rank-but-not-capturing-everything-sample
Sheet: Sheet2

CAT LOOK UP | UNITS | SALES ACTUAL RANK | Manual ranking
BABY ACCESSORIES | 3 |  | 1
BABY ACCESSORIES | 2 |  | 2
BABY ACCESSORIES | 1 |  | 3
BABY ACCESSORIES | 1 |  | 4
BABY ACCESSORIES | 1 |  | 5
BABY ACCESSORIES - BIBS | 6 |  | 1
BABY ACCESSORIES - BIBS | 4 |  | 2
BABY ACCESSORIES - BIBS | 1 |  | 3
BABY ACCESSORIES - BIBS | 1 |  | 4
BABY ACCESSORIES - BOTTLES | 4 |  | 1
BABY ACCESSORIES - BOTTLES | 2 |  | 2
BABY ACCESSORIES - DUMMIES | 1 |  | 1
BABY ACCESSORIES - DUMMIES | 1 |  | 2
BABY ACCESSORIES - TOYS | 3 |  | 1
BABYGROWS | 35 |  | 1
BABYGROWS | 32 |  | 2
BABYGROWS | 26 |  | 3
BABYGROWS | 22 |  | 4
BABYGROWS | 19 |  | 5
BABYGROWS | 19 |  | 6
BABYGROWS | 16 |  | 7
BABYGROWS | 16 |  | 8
BABYGROWS | 14 |  | 9
BABYGROWS | 11 |  | 10
BABYGROWS | 9 |  | 11
BABYGROWS | 8 |  | 12
BABYGROWS | 8 |  | 13
BABYGROWS | 7 |  | 14
BABYGROWS | 6 |  | 15
BABYGROWS | 6 |  | 16
BABYGROWS | 6 |  | 17
BABYGROWS | 6 |  | 18
BABYGROWS | 6 |  | 19
BABYGROWS | 6 |  | 20
BABYGROWS | 5 |  | 21
BABYGROWS | 5 |  | 22
BABYGROWS | 4 |  | 23
BABYGROWS | 4 |  | 24
BABYGROWS | 3 |  | 25
BABYGROWS | 3 |  | 26
BABYGROWS | 3 |  | 27
BABYGROWS | 3 |  | 28
BABYGROWS | 3 |  | 29
BABYGROWS | 3 |  | 30
BABYGROWS | 3 |  | 31
BABYGROWS | 3 |  | 32
BABYGROWS | 3 |  | 33
BABYGROWS | 3 |  | 34
BABYGROWS | 3 |  | 35
BABYGROWS | 3 |  | 36
BABYGROWS | 2 |  | 37
BABYGROWS | 2 |  | 38
BABYGROWS | 2 |  | 39
BABYGROWS | 2 |  | 40
BABYGROWS | 2 |  | 41
BABYGROWS | 2 |  | 42
BABYGROWS | 2 |  | 43
BABYGROWS | 2 |  | 44
BABYGROWS | 2 |  | 45
BABYGROWS | 2 |  | 46
BABYGROWS | 2 |  | 47
BABYGROWS | 2 |  | 48
BABYGROWS | 2 |  | 49
BABYGROWS | 2 |  | 50
BABYGROWS | 2 |  | 51
BABYGROWS | 2 |  | 52
BABYGROWS | 1 |  | 53
BABYGROWS | 1 |  | 54
BABYGROWS | 1 |  | 55
BABYGROWS | 1 |  | 56
BABYGROWS | 1 |  | 57
BABYGROWS | 1 |  | 58
BABYGROWS | 1 |  | 59
BABYGROWS | 1 |  | 60
BABYGROWS | 1 |  | 61
BABYGROWS | 1 |  | 62
BABYGROWS | 1 |  | 63
BABYGROWS | 1 |  | 64
BABYGROWS | 1 |  | 65
BABYGROWS | 1 |  | 66
BABYGROWS | 1 |  | 67
BABYGROWS | 1 |  | 68
BABYGROWS | 1 |  | 69
BABYGROWS | 1 |  | 70
BABYGROWS | 1 |  | 71
BABYGROWS | 1 |  | 72
BABYGROWS | 1 |  | 73
BABYGROWS | 1 |  | 74
BABYGROWS | 1 |  | 75
BABYGROWS | 1 |  | 76
BABYGROWS | 1 |  | 77
BABYGROWS | 1 |  | 78
BABYGROWS | 1 |  | 79
BABYGROWS | 1 |  | 80
BABYGROWS | 1 |  | 81
BABYGROWS | 1 |  | 82
BABYGROWS | 1 |  | 83
BABYGROWS | 0 |  | 84
BABYGROWS | -1 |  | 85
BABYGROWS | -1 |  | 86
BABYWEAR | 2 |  | 1
BABYWEAR | 1 |  | 2
BABYWEAR | 1 |  | 3
BABYWEAR | 1 |  | 4
BABYWEAR | 1 |  | 5
BABYWEAR | 1 |  | 6
BABYWEAR | 1 |  | 7
BABYWEAR | 1 |  | 8
BABYWEAR | 1 |  | 9
BABYWEAR | 1 |  | 10
BABYWEAR | 1 |  | 11
BABYWEAR | 0 |  | 12
[NAME] | 29 |  | 1
[NAME] | 18 |  | 2
[NAME] | 13 |  | 3
[NAME] | 11 |  | 4
[NAME] | 10 |  | 5
[NAME] | 10 |  | 6
[NAME] | 9 |  | 7
[NAME] | 6 |  | 8
[NAME] | 6 |  | 9
[NAME] | 5 |  | 10
[NAME] | 5 |  | 11
[NAME] | 5 |  | 12
[NAME] | 5 |  | 13
[NAME] | 5 |  | 14
[NAME] | 4 |  | 15
[NAME] | 3 |  | 16
[NAME] | 3 |  | 17
[NAME] | 3 |  | 18
[NAME] | 3 |  | 19
[NAME] | 3 |  | 20
[NAME] | 3 |  | 21
[NAME] | 3 |  | 22
[NAME] | 3 |  | 23
[NAME] | 3 |  | 24
[NAME] | 3 |  | 25
[NAME] | 3 |  | 26
[NAME] | 3 |  | 27
[NAME] | 3 |  | 28
[NAME] | 3 |  | 29
[NAME] | 3 |  | 30
[NAME] | 3 |  | 31
[NAME] | 3 |  | 32
[NAME] | 3 |  | 33
[NAME] | 3 |  | 34
[NAME] | 3 |  | 35
[NAME] | 2 |  | 36
[NAME] | 2 |  | 37
[NAME] | 2 |  | 38
[NAME] | 2 |  | 39
[NAME] | 2 |  | 40
[NAME] | 2 |  | 41
[NAME] | 2 |  | 42
[NAME] | 2 |  | 43
[NAME] | 2 |  | 44
[NAME] | 2 |  | 45
[NAME] | 2 |  | 46
[NAME] | 2 |  | 47
[NAME] | 2 |  | 48
[NAME] | 2 |  | 49
[NAME] | 2 |  | 50
[NAME] | 2 |  | 51
[NAME] | 2 |  | 52
[NAME] | 2 |  | 53
[NAME] | 2 |  | 54
[NAME] | 2 |  | 55
[NAME] | 2 |  | 56
[NAME] | 2 |  | 57
[NAME] | 2 |  | 58
[NAME] | 2 |  | 59
[NAME] | 2 |  | 60
[NAME] | 2 |  | 61
[NAME] | 1 |  | 62
[NAME] | 1 |  | 63
[NAME] | 1 |  | 64
[NAME] | 1 |  | 65
[NAME] | 1 |  | 66
[NAME] | 1 |  | 67
[NAME] | 1 |  | 68
[NAME] | 1 |  | 69
[NAME] | 1 |  | 70
[NAME] | 1 |  | 71
[NAME] | 1 |  | 72
[NAME] | 1 |  | 73
[NAME] | 1 |  | 74
[NAME] | 1 |  | 75
[NAME] | 1 |  | 76
[NAME] | 1 |  | 77
[NAME] | 1 |  | 78
[NAME] | 1 |  | 79
[NAME] | 1 |  | 80
[NAME] | 1 |  | 81
[NAME] | 1 |  | 82
[NAME] | 1 |  | 83
[NAME] | 1 |  | 84
[NAME] | 1 |  | 85
[NAME] | 1 |  | 86
[NAME] | 1 |  | 87
[NAME] | 1 |  | 88
[NAME] | 1 |  | 89
[NAME] | 1 |  | 90
[NAME] | 1 |  | 91
[NAME] | 1 |  | 92
[NAME] | 1 |  | 93
[NAME] | 1 |  | 94
[NAME] | 1 |  | 95
[NAME] | 1 |  | 96
[NAME] | 1 |  | 97
[NAME] | 1 |  | 98
[NAME] | 1 |  | 99
[NAME] | 1 |  | 100
[NAME] | 1 |  | 101
[NAME] | 1 |  | 102
[NAME] | 1 |  | 103
[NAME] | 1 |  | 104
[NAME] | 1 |  | 105
[NAME] | -1 |  | 106
[NAME] | -1 |  | 107
[NAME] | -1 |  | 108
[NAME] | 6 |  | 1
[NAME] | 3 |  | 2
[NAME] | 3 |  | 3
[NAME] | 2 |  | 4
[NAME] | 2 |  | 5
[NAME] | 1 |  | 6
[NAME] | 1 |  | 7
BELTS | 9 |  | 1
BELTS | 8 |  | 2
BELTS | 7 |  | 3
BELTS | 5 |  | 4
BELTS | 4 |  | 5
BELTS | 4 |  | 6
BELTS | 4 |  | 7
BELTS | 4 |  | 8
BELTS | 3 |  | 9
BELTS | 2 |  | 10
BELTS | 2 |  | 11
BELTS | 1 |  | 12
BELTS | 1 |  | 13
BELTS | 1 |  | 14
BELTS | 1 |  | 15
BELTS | 1 |  | 16
BELTS | 1 |  | 17
BELTS | 1 |  | 18
BIKINI | 4 |  | 1
BIKINI | 2 |  | 2
BIKINI | 2 |  | 3
BIKINI | 1 |  | 4
BIKINI | 1 |  | 5
BIKINI | 1 |  | 6
BIKINI | 1 |  | 7
BIKINI | 1 |  | 8
BIKINI | 1 |  | 9
BIKINI | 1 |  | 10
BIKINI | 1 |  | 11
BIKINI | -1 |  | 12
BIKINI | -1 |  | 13
BIKINI | -1 |  | 14
BIKINI | -1 |  | 15
BIKINI | -1 |  | 16
BIKINI | -1 |  | 17
BIKINI | -1 |  | 18
BIKINI | -1 |  | 19
BIKINI | -2 |  | 20
BIKINI | -2 |  | 21