How to make 2 different cells, cumulative in another, on another sheet?

I have a materials list that I am trying to figure out the formula for. I want to take part quantities from one sheet, and put them on an order sheet. With part numbers referenced from another sheet. Here is some screen shots.assemblies.PNG I would like to take the quantities from Column D of the assembly sheet and Accumulate like parts into one line on the material order sheet. And if I have blank cells, with no quantities, how can I keep them from being on my material order sheet? I can do the vlookup on the part number from the material order sheet. Just stuck on those 2 problems. Thanks in advance for any help.

here is the other screen shot. Material order.PNG

Originally Posted by FDibbins

Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you

Take a look at using sumif() and sumifS()

I was told on another thread how to screenshot. I thought that was what people preferred. I would gladly post up my workbook, if someone can tell me how? I don't mind sharing at all. As a matter of fact, I will share the finished product, with anyone who might find it useful. I really appreciate you helping me, and in return, I will make available what I have with others. So, how do I put my worksheet on here? And Thanks for the help, as always.

Job sheet.xlsx I think, I figured it out? If this opens, let me know. I will explain what I am wanting to do.

When I use the drop down lists in "Materials" tab column "C" to choose a component. I then fill in a quantity in column "D".
I would like for it to add that part to "Primary Material Order" Tab Columns "B" and quantity to Column "F". If on "Materials" Tab, the part is duplicated in other assemblies, I would like for it to add to parts already on the "Primary Material Order" tab. Instead of making a new line. If lines are left blank on "Materials" tab, how do I make the "Primary Material Order" tab ignore them? I don't want my "Primary Material Order" having a bunch of blank lines, or duplicate parts and quantities, is the easiest way to say it. But, I want to transpose parts from "Materials" tab to "Primary Materials Order" Tab. ?????Sounds complicated to me, hope it doesn't to somebody? LOL Thanks for the help.

Play thing TEMP.xlsxThis should be a better representation of what is wrong with my spreadsheet. And, what I am trying to accomplish. All cells are unlocked so you can see the formulas, that I have in place. What do I need to do to make it simple to use, that is the key. Thanks

Thanks to Both of you! I wanted to calc qnty, not costs. But, I figured that much out. I really appreciate your help. Starring both of you, and calling this solved!

Originally Posted by FDibbins

Not sure what NewDoverman offered (will look later), but see if this will get you headed in the right diredction?

It used a helper in materials to remove blank rows, andthen uses sumif to calc the costs

I know this is closed, but I have a question. I have redone some of my spread sheet. I need to change around some of the formulas, you added in. I would like for you to explain the function of the formula? What it means, so I will understand, what it does? I am attaching my new excel sheet.8044.xlsx

The idea of this sheet is to be able to randomly name assemblies in column "A" of the "***" Tab, I need to change that ones name!. Pick from the drop down list of groups in Column "C", Then pick from the dropdown list in column "D", then enter a quantity in column "E", Which calculates a total price in Column "D". It also is supposed to Build a "1st PO" on the tab named so. Tabulating the parts quantities on that tab for order. It used to work, before I started monkeying with it. If you could explain what the fomulas in column "F" do, it would hopefully make me understand how to fix it. Thanks

Assembly Tab.jpgThis is a screen shot of what I have. I just don't understand the formula? Or what it does? Only thing I realize, is, my end result is not right.