Forum Discussion
Formula Help Required
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.