Spreadsheet: 717601d1612769287-sumif-based-on-2-criteria-from-2-sheets-test-report
Sheet: groups

Number | Over Group | Article No | Item Group | Major Group
11500084 | Beverage | GROCERIES | COFFEE AND TEA | GROCERIES
12200017 | Beverage | NON ALCOHOLIC BEVERAGES | FLAVOUR WATER AND SYRUP | NON ALCOHOLIC BEVERAGES
16000002 | Beverage | NON ALCOHOLIC BEVERAGES | SOFTDRINKS | NON ALCOHOLIC BEVERAGES
16000003 | Beverage | NON ALCOHOLIC BEVERAGES | SOFTDRINKS | NON ALCOHOLIC BEVERAGES
16000005 | Beverage | NON ALCOHOLIC BEVERAGES | SOFTDRINKS | NON ALCOHOLIC BEVERAGES
16000006 | Beverage | NON ALCOHOLIC BEVERAGES | SOFTDRINKS | NON ALCOHOLIC BEVERAGES
16000008 | Beverage | NON ALCOHOLIC BEVERAGES | SOFTDRINKS | NON ALCOHOLIC BEVERAGES
16000010 | Beverage | NON ALCOHOLIC BEVERAGES | SOFTDRINKS | NON ALCOHOLIC BEVERAGES
16000011 | Beverage | NON ALCOHOLIC BEVERAGES | SOFTDRINKS | NON ALCOHOLIC BEVERAGES
16000012 | Beverage | NON ALCOHOLIC BEVERAGES | SOFTDRINKS | NON ALCOHOLIC BEVERAGES
16000032 | Beverage | NON ALCOHOLIC BEVERAGES | SOFTDRINKS | NON ALCOHOLIC BEVERAGES
20000001 | Beverage | LIQUOR | APERITIF | LIQUOR
20000004 | Beverage | LIQUOR | APERITIF | LIQUOR
20100012 | Beverage | BEER | BEER BOTTLED | BEER
20100013 | Beverage | BEER | BEER BOTTLED | BEER
20100016 | Beverage | BEER | BEER BOTTLED | BEER
20100021 | Beverage | BEER | BEER BOTTLED | BEER
20100022 | Beverage | BEER | BEER BOTTLED | BEER
20100044 | Beverage | BEER | BEER BOTTLED | BEER
20200001 | Beverage | BEER | [NAME] | BEER
20300002 | Beverage | BEER | BEER DRAUGHT | BEER
20300003 | Beverage | BEER | BEER DRAUGHT | BEER
20300017 | Beverage | BEER | BEER DRAUGHT | BEER
20400003 | Beverage | LIQUOR | BRANDY | LIQUOR
20450001 | Beverage | WINE | CHAMPAGNE NON VINTAGE | WINE
20550001 | Beverage | LIQUOR | COGNAC | LIQUOR
20600001 | Beverage | LIQUOR | GIN | LIQUOR
20600004 | Beverage | LIQUOR | GIN | LIQUOR
20600013 | Beverage | LIQUOR | GIN | LIQUOR
20600014 | Beverage | LIQUOR | GIN | LIQUOR
20600025 | Beverage | LIQUOR | GIN | LIQUOR
20600034 | Beverage | LIQUOR | GIN | LIQUOR
20750046 | Beverage | LIQUOR | LIQUERS | LIQUOR
20750066 | Beverage | LIQUOR | LIQUERS | LIQUOR
20750089 | Beverage | LIQUOR | LIQUERS | LIQUOR
20750093 | Beverage | LIQUOR | LIQUERS | LIQUOR
20750099 | Beverage | LIQUOR | LIQUERS | LIQUOR
20850010 | Beverage | WINE | RED WINE AMERICAN | WINE
21050001 | Beverage | WINE | RED WINE AUSTRALIAN | WINE
21750015 | Beverage | WINE | RED WINE SOUTH AFRICA | WINE
21850001 | Beverage | WINE | RED WINE SPAIN | WINE
21850003 | Beverage | WINE | RED WINE SPAIN | WINE
21950002 | Beverage | WINE | ROSE WINE | WINE
22050004 | Beverage | LIQUOR | RUM | LIQUOR
22050007 | Beverage | LIQUOR | RUM | LIQUOR
22050010 | Beverage | LIQUOR | RUM | LIQUOR
22050012 | Beverage | LIQUOR | RUM | LIQUOR
22200006 | Beverage | WINE | SPARKLING WINE | WINE
22250001 | Beverage | LIQUOR | TEQUILA | LIQUOR
22250003 | Beverage | LIQUOR | TEQUILA | LIQUOR
22250020 | Beverage | LIQUOR | TEQUILA | LIQUOR
22350002 | Beverage | LIQUOR | VODKA | LIQUOR
22350004 | Beverage | LIQUOR | VODKA | LIQUOR
22450002 | Beverage | LIQUOR | WHISKY | LIQUOR
22450003 | Beverage | LIQUOR | WHISKY | LIQUOR
22450006 | Beverage | LIQUOR | WHISKY | LIQUOR
22450023 | Beverage | LIQUOR | WHISKY | LIQUOR
22450024 | Beverage | LIQUOR | WHISKY | LIQUOR
22450080 | Beverage | LIQUOR | WHISKY | LIQUOR
23150019 | Beverage | WINE | WHITE WINE FRENCH | WINE
23150033 | Beverage | WINE | WHITE WINE FRENCH | WINE
23350001 | Beverage | WINE | WHITE WINE ITALIAN | WINE
23350002 | Beverage | WINE | WHITE WINE ITALIAN | WINE
23650013 | Beverage | WINE | WHITE WINE SOUTH AFRICA | WINE
24150002 | Beverage | CIGARETTES | CIGARETTES | CIGARETTES
24150003 | Beverage | CIGARETTES | CIGARETTES | CIGARETTES