Spreadsheet: 797002d1663667642-using-sumproduct-to-conditionally-rank-but-not-capturing-everything-sample
Sheet: Sheet2

CAT LOOK UP | UNITS | SALES ACTUAL RANK
BABY ACCESSORIES | 3
BABY ACCESSORIES | 2
BABY ACCESSORIES | 1
BABY ACCESSORIES | 1
BABY ACCESSORIES | 1
BABY ACCESSORIES - BIBS | 6
BABY ACCESSORIES - BIBS | 4
BABY ACCESSORIES - BIBS | 1
BABY ACCESSORIES - BIBS | 1
BABY ACCESSORIES - BOTTLES | 4
BABY ACCESSORIES - BOTTLES | 2
BABY ACCESSORIES - DUMMIES | 1
BABY ACCESSORIES - DUMMIES | 1
BABY ACCESSORIES - TOYS | 3
BABYGROWS | 35
BABYGROWS | 32
BABYGROWS | 26
BABYGROWS | 22
BABYGROWS | 19
BABYGROWS | 19
BABYGROWS | 16
BABYGROWS | 16
BABYGROWS | 14
BABYGROWS | 11
BABYGROWS | 9
BABYGROWS | 8
BABYGROWS | 8
BABYGROWS | 6
BABYGROWS | 7
BABYGROWS | 6
BABYGROWS | 6
BABYGROWS | 6
BABYGROWS | 5
BABYGROWS | 6
BABYGROWS | 6
BABYGROWS | 3
BABYGROWS | 3
BABYGROWS | 5
BABYGROWS | 4
BABYGROWS | 3
BABYGROWS | 3
BABYGROWS | 4
BABYGROWS | 3
BABYGROWS | 2
BABYGROWS | 3
BABYGROWS | 2
BABYGROWS | 2
BABYGROWS | 3
BABYGROWS | 2
BABYGROWS | 3
BABYGROWS | 2
BABYGROWS | 3
BABYGROWS | 3
BABYGROWS | 3
BABYGROWS | 1
BABYGROWS | 2
BABYGROWS | 1
BABYGROWS | 2
BABYGROWS | 1
BABYGROWS | 3
BABYGROWS | 1
BABYGROWS | 1
BABYGROWS | 2
BABYGROWS | 1
BABYGROWS | 1
BABYGROWS | 2
BABYGROWS | 2
BABYGROWS | 1
BABYGROWS | 2
BABYGROWS | 2
BABYGROWS | 2
BABYGROWS | 2
BABYGROWS | 2
BABYGROWS | 1
BABYGROWS | 2
BABYGROWS | 0
BABYGROWS | -1
BABYGROWS | -1
BABYGROWS | 1
BABYGROWS | 1
BABYGROWS | 1
BABYGROWS | 1
BABYGROWS | 1
BABYGROWS | 1
BABYGROWS | 1
BABYGROWS | 1
BABYGROWS | 1
BABYGROWS | 1
BABYGROWS | 1
BABYGROWS | 1
BABYGROWS | 1
BABYGROWS | 1
BABYGROWS | 1
BABYGROWS | 1
BABYGROWS | 1
BABYGROWS | 1
BABYGROWS | 1
BABYGROWS | 1
BABYGROWS | 1
BABYGROWS | 1
BABYWEAR | 1
BABYWEAR | 2
BABYWEAR | 1
BABYWEAR | 0
BABYWEAR | 1
BABYWEAR | 1
BABYWEAR | 1
BABYWEAR | 1
BABYWEAR | 1
BABYWEAR | 1
BABYWEAR | 1
BABYWEAR | 1
[NAME] | 29
[NAME] | 18
[NAME] | 13
[NAME] | 10
[NAME] | 11
[NAME] | 10
[NAME] | 9
[NAME] | 5
[NAME] | 5
[NAME] | 5
[NAME] | 5
[NAME] | 6
[NAME] | 5
[NAME] | 6
[NAME] | 3
[NAME] | 3
[NAME] | 4
[NAME] | 3
[NAME] | 3
[NAME] | 3
[NAME] | 3
[NAME] | 3
[NAME] | 3
[NAME] | 3
[NAME] | 2
[NAME] | 3
[NAME] | 3
[NAME] | 3
[NAME] | 2
[NAME] | 3
[NAME] | 2
[NAME] | 3
[NAME] | 3
[NAME] | 3
[NAME] | 2
[NAME] | 3
[NAME] | 3
[NAME] | 3
[NAME] | 2
[NAME] | 3
[NAME] | 2
[NAME] | 2
[NAME] | 2
[NAME] | 2
[NAME] | 2
[NAME] | 2
[NAME] | 2
[NAME] | 1
[NAME] | 1
[NAME] | 2
[NAME] | 2
[NAME] | 1
[NAME] | 2
[NAME] | 1
[NAME] | 2
[NAME] | 2
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 2
[NAME] | 2
[NAME] | 2
[NAME] | 2
[NAME] | 2
[NAME] | 1
[NAME] | 2
[NAME] | 2
[NAME] | 1
[NAME] | 2
[NAME] | 2
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | -1
[NAME] | -1
[NAME] | -1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 6
[NAME] | 3
[NAME] | 3
[NAME] | 2
[NAME] | 2
[NAME] | 1
[NAME] | 1
BELTS | 9
BELTS | 8
BELTS | 7
BELTS | 4
BELTS | 4
BELTS | 5
BELTS | 4
BELTS | 4
BELTS | 2
BELTS | 2
BELTS | 3
BELTS | 1
BELTS | 1
BELTS | 1
BELTS | 1
BELTS | 1
BELTS | 1
BELTS | 1
BIKINI | 2
BIKINI | 4
BIKINI | -1
BIKINI | -1
BIKINI | -1
BIKINI | -2
BIKINI | -1
BIKINI | -2
BIKINI | -1
BIKINI | -1
BIKINI | -1
BIKINI | -1
BIKINI | 2
BIKINI | 1
BIKINI | 1
BIKINI | 1
BIKINI | 1
BIKINI | 1
BIKINI | 1
BIKINI | 1
BIKINI | 1