Sumifs formual using multiple Criteria under one Criteria_Range

[Dial1]

I am looking for a sumifs() formula that I can use that will have multiple Criteria_Ranges&Criteria however, for one of the Criteria_Ranges I only want the formula to return the sum of a specific Criteria within the range despite having multiple matches for all other criteria. I have presented an example using Part #'s of cars and trucks and the inventory quantity. In real world usage there are hundreds of part numbers. I only want to sum 3 specific part numbers within the range. I thought I could use {part #, part#, part#} in the criteria but it is only returning the value of the first listed part #. See attached and let me know if you have any suggestions.

Thank you,

[JohnTopley]

Try ..

=SUMPRODUCT((E4:E10)*(C4:C10={9407,2035,9409}))

Enter with Ctrl+shift+Enter

OR

=SUMIF(C4:C10,9407,E4:E10)+SUMIF(C4:C10,2035,E4:E10)+SUMIF(C4:C10,9409,E4:E10)

[hoyasaxa215]

May also want to consider using a pivot table.