hi all,
I have a sheet which contains data sets (3 rows per data set), see Product Level sheet of attachment. I want to consolidate and total the numbers into the total sheet.
Example; Material ID A and Material ID C are paired in Product Level sheet. I want a way of addView attachment Production stocks total.xlsxing together their attributes (column J) of Product Level sheet and include in the Total sheet.
I have manually input a calculation in the total sheet so you can better understand.
Please not the order of the paired data sets in the Product Level sheet will be random (so I will need formulas that update in the Total sheet automatically, whenever there is a change in the Product Level sheet).
Hope this makes sense and thanks in advance for the help
I have a sheet which contains data sets (3 rows per data set), see Product Level sheet of attachment. I want to consolidate and total the numbers into the total sheet.
Example; Material ID A and Material ID C are paired in Product Level sheet. I want a way of addView attachment Production stocks total.xlsxing together their attributes (column J) of Product Level sheet and include in the Total sheet.
I have manually input a calculation in the total sheet so you can better understand.
Please not the order of the paired data sets in the Product Level sheet will be random (so I will need formulas that update in the Total sheet automatically, whenever there is a change in the Product Level sheet).
Hope this makes sense and thanks in advance for the help