Results 1 to 2 of 2

Thread: Consolidate paired data sets

  1. #1
    Neophyte GLewis14's Avatar
    Join Date
    Nov 2020
    Posts
    1
    Articles
    0
    Excel Version
    365

    Consolidate paired data sets



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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 addProduction 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

  2. #2
    Seeker RET's Avatar
    Join Date
    Nov 2020
    Location
    Spain
    Posts
    10
    Articles
    0
    Excel Version
    2019
    Start by identifying each row, not only one out of 3 and then use SUMIF

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •