SUMIF problem

R

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
 
J

Jack Schitt

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

Jack Schitt

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

Aladin Akyurek

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

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