Spreadsheet: 683224d1592566767-more-efficient-formula-for-multiple-sumif-statements-book1
Sheet:  Week 1 - Meat

WEEK ONE |  |  |  |  |  |  |  |  |  |  |  |  |  | POB |  |  | 400
 | Breakfast | % | No | Scale | Weight | Order | Lunch | % | No | Scale | Weight | Order | Dinner | % | No | Scale | Weight | Order
MONDAY | Bacon Rashers (Rind Off) 2.5kg vacuum packed | 50 |  | 0.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1 | Bacon | Cold Meats
 |  |  |  |  |  |  | Bacon Rashers (Rind Off) 2.5kg vacuum packed | 30 |  | 0.1 |  |  | [NAME] | 30 |  | 0.2 |  |  |  | 0.15 | Pizza Toppings | [NAME]
 |  |  |  |  |  |  | [NAME] (Bone out) Skinless | 35 |  | 0.2 |  |  | [NAME] | 35 |  | 0.25 |  |  |  | 0.166 | Wet Dishes | [NAME] | Mince Wet Dishes
 | Cold Meats |  |  |  |  |  | [NAME], Rolled, Tied | 35 |  | 0.15 |  |  | [NAME] (Bone out) Skinless | 35 |  | 0.25 |  |  |  | 0.2 | Roast Bonless | Protein Boneless | Mince
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.25 | [NAME] In | Seafood | Sausages
 | Ham Virginia Fresh, sliced | 20 |  | 0.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.4 | [NAME] | Lamb Racks
 | Pastrami | 10 |  | 0.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Pies | Sausage Rolls | Schnitzel | Hamburgers
 |  |  |  |  |  |  | Total |  |  |  |  |  | Total |  |  |  |  |  |  | 3 | [NAME]
 | Victualled For |  |  |  |  |  | Victualled For |  |  |  |  |  | Victualled For
TUESDAY | Bacon Rashers (Rind Off) 2.5kg vacuum packed | 60 |  | 0.1
 | Sausages [NAME] | 20 |  | 0.1 |  |  | [NAME] (Bone out) Skinless | 15 |  | 0.166 |  |  | Chicken Schnitzel QF | 50 |  | 1
 |  |  |  |  |  |  | [NAME] | 15 |  | 0.2 |  |  | [NAME] | 35 |  | 0.166
 | Cold Meats |  |  |  |  |  | Pork Leg Boned, Rolled and Netted | 40 |  | 0.15 |  |  | SALMON PORTIONS S/ON 200GR SCALED (APP 25/CTN) | 15 |  | 0.2
 |  |  |  |  |  |  | [NAME] | 30 |  | 0.15
 | [NAME] | 10 |  | 0.1
 | [NAME] sliced | 10 |  | 0.1
 |  |  |  |  |  |  | Total |  |  |  |  |  | Total
 | Victualled For |  |  |  |  |  | Victualled For |  |  |  |  |  | Victualled For
WEDNESDAY | Bacon Rashers (Rind Off) 2.5kg vacuum packed | 80 |  | 0.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1 | Bacon | Cold Meats
 |  |  |  |  |  |  | Burger Patties Beef Angus Gourmet | 50 |  | 1 |  |  | [NAME] (Bone out) Skinless | 35 |  | 0.166 |  |  |  | 0.15 | Pizza Toppings
 |  |  |  |  |  |  | [NAME] | 30 |  | 1 |  |  | Beef Cube Roll | 30 |  | 0.25 |  |  |  | 0.166 | Wet Dishes | [NAME] | Mince Wet Dishes
 | Cold Meats |  |  |  |  |  | [NAME] 200/300 | 20 |  | 0.2 |  |  | Lamb Foreshank | 35 |  | 0.4 |  |  |  | 0.2 | Roast Bonless | Protein Boneless | Mince
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.25 | [NAME] In | Seafood | Sausages
 | Turkey Roll Fresh, sliced | 10 |  | 0.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.4 | [NAME]
 | [NAME] | 10 |  | 0.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Pies | Sausage Rolls | Schnitzel | Hamburgers
 |  |  |  |  |  |  | Total |  |  |  |  |  | Total |  |  |  |  |  |  | 3 | [NAME]
 | Victualled For |  |  |  |  |  | Victualled For |  |  |  |  |  | Victualled For
THURSDAY | Bacon Rashers (Rind Off) 2.5kg vacuum packed | 60 |  | 0.1
 |  |  |  |  |  |  | Bacon Rashers (Rind Off) 2.5kg vacuum packed | 15 |  | 0.1 |  |  | [NAME] (Bone out) Skinless
 |  |  |  |  |  |  | Pork Eye Loin | 40 |  | 0.2 |  |  | [NAME], Rolled, Tied
 | Cold Meats |  |  |  |  |  | [NAME] (Bone out) Skinless | 45 |  | 0.2 |  |  | Pork Loin Chops
 | Ham Virginia Fresh, sliced
 | Pastrami
 |  |  |  |  |  |  | Total |  |  |  |  |  | Total
 | Victualled For |  |  |  |  |  | Victualled For |  |  |  |  |  | Victualled For
FRIDAY | Bacon Rashers (Rind Off) 2.5kg vacuum packed | 60 |  | 0.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1 | Bacon | Cold Meats
 | Sausages [NAME] | 20 |  | 0.15 |  |  | Beef Topside | 30 |  | 0.2 |  |  | Beef Diced | 30 |  | 0.166 |  |  |  | 0.15 | Pizza Toppings
 |  |  |  |  |  |  | Snapper Goldband Flt S/on 300/500 Wild | 40 |  | 0.2 |  |  | [NAME] (Bone out) Skinless | 30 |  | 0.25 |  |  |  | 0.166 | Wet Dishes | [NAME] | Mince Wet Dishes
 | Cold Meats |  |  |  |  |  | [NAME] (Bone out) Skinless | 30 |  | 0.166 |  |  | [NAME] | 40 |  | 0.4 |  |  |  | 0.2 | Roast Bonless | Protein Boneless | Mince
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.25 | [NAME] In | Seafood | Sausages
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.4 | [NAME]
 | Turkey Roll Fresh, sliced |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Pies | Sausage Rolls | Schnitzel | Hamburgers
 |  |  |  |  |  |  | Total |  |  |  |  |  | Total |  |  |  |  |  |  | 3 | [NAME]
 | Victualled For |  |  |  |  |  | Victualled For |  |  |  |  |  | Victualled For
SATURDAY | Bacon Rashers (Rind Off) 2.5kg vacuum packed
 |  |  |  |  |  |  | Burger Patties Beef Angus Gourmet | 40 |  | 1 |  |  | [NAME] | 40 |  | 0.2
 |  |  |  |  |  |  | [NAME] (Buffet) | 30 |  | 0.25 |  |  | [NAME] | 30 |  | 0.2
 | Cold Meats |  |  |  |  |  | Bacon Rashers (Rind Off) 2.5kg vacuum packed | 30 |  | 0.1 |  |  | [NAME] U/5 | 30 |  | 0.25
 | [NAME] | 10 |  | 0.1
 | Mortedella | 10 |  | 0.1
 |  |  |  |  |  |  | Total |  |  |  |  |  | Total
 | Victualled For |  |  |  |  |  | Victualled For |  |  |  |  |  | Victualled For
SUNDAY | Bacon Rashers (Rind Off) 2.5kg vacuum packed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1 | Bacon | Cold Meats
 |  |  |  |  |  |  | Chicken Schnitzel QF | 40 |  | 1 |  |  | Beef Diced | 20 |  | 0.2 |  |  |  | 0.15 | Pizza Toppings
 |  |  |  |  |  |  | [NAME] | 30 |  | 0.166 |  |  | [NAME] (Bone out) Skinless | 30 |  | 0.166 |  |  |  | 0.166 | Wet Dishes | [NAME] | Mince Wet Dishes
 | Cold Meats |  |  |  |  |  | Beef Cube Roll | 30 |  | 0.2 |  |  | [NAME], Rolled, Tied | 25 |  | 0.2 |  |  |  | 0.2 | Roast Bonless | Protein Boneless | Mince
 |  |  |  |  |  |  |  |  |  |  |  |  | Pork Belly | 25 |  | 0.2 |  |  |  | 0.25 | [NAME] In | Seafood | Sausages
 | Ham Virginia Fresh, sliced | 10 |  | 0.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.4 | [NAME]
 | Pastrami | 10 |  | 0.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Pies | Sausage Rolls | Schnitzel | Hamburgers
 |  |  |  |  |  |  | Total |  |  |  |  |  | Total |  |  |  |  |  |  | 3 | [NAME]
 | Victualled For |  |  |  |  |  | Victualled For |  |  |  |  |  | Victualled For