Summarize amount dependend on part number (dynamic)

[joejonson]

Hi, I'm getting crazy with this problem!

I have created a row with parts and there related production number (they are dynamic) -> than I have made in column A a function to kick out double names in column E (formulas and excel example are in the attached PDF file)-> I want to have in column F the summarized number related to the parts in column E, please note that this must be dynamic!!!

Could someone of you help me???

Thx a lot!

[joejonson]

:D oke I found out, I have to use the sumif-function!