Forum Discussion
Formula Help Required
Good Morning,
I have started creating a sheet which works out transport weight and packaging required based on orders from our customer. I am after a formula to look at the Packaging Type and the quantities required and compile a packaging order list. The sheet would then tell me how many H Lids etc and then how many R lids etc.
Sheet attached.
I am looking to put the formula in boxes B27 to E30.
Cheers
2 Replies
Can you please put your desired output to B27 to E30 manually so that we can make it by formula. Also please explain a little more about logic to gain that output.
Good Morning Harun,
Thank you for your response.
Each part number requires certain packaging. This packaging is determined by the type in column B. Columns E-H are the quantities required of that packaging to make up a set. For instance row 3 would add 1 in to B27, 28 and 29 as colums E-H are asking for 1 of each Lid, pallet and collars. Row 4 would ask for 1 Lid, 1 pallet and 3 collars. So based on the type of packaging, the formula needs to count the required Lids, Pallets, Collars and Polybox and add them up in the correct boxes B27-E30. All H Lids in B 27, R lids in C 27 and so on.
Formula to Look at the packaging type, then look at the headings (e2 etc) and count the quantities up.
Does that clear it up?
I've attached the sheet with a manual calculation in the table.
