SUMIF problem

[R0bert0]

I need to figure out how to return the sum of cells matching 2 criteria
If possible one of these criteria should be something I specify i
quotation marks such as
"RAB14"

I want it to SUMIF but I need it to match a part number and then
press number from a list in a separate workbook.

Thank

 

[Jack Schitt]

Try
=SUMPRODUCT(range*(Condition1)*(Condition2))
Condition1 might be something like
range="RAB14"

 

[Jack Schitt]

"range" and "range" are of course two different ranges in that example.
Sorry, not clear.

 

[Aladin Akyurek]

=SUMPRODUCT(--(PartsRange=E2),--(PressRange=F2),RangeToSum)

where E2 houses a part number of interest and F2 a press number of interest.