Sum formula to total from another worksheet

[workme321]

I need a sum formula to total from another worksheet, I want it to recognize the size cell, name of product cell and quantity cell to pull the right quantity.

Please and thank you.

 

[Michael M]

Probably a small sample of data and the expected result would help.

 

[keda duck]

Can you give an example?

 

[awoohaw]

Not sure, but you seem to have some ambiguity in the statement "quantity cell to pull the right quantity" why do you need to retreive the quantity when you already know it?

Assuming you want a "stock on hand" kind of result, use this and replace the cell/range descriptions with the appropriate cell references.

=SUMIFS(OtherWorksheet!QuantityRange,Otherworksheet!SizeRange, TargetSize, OtherWorksheet!ProductNameRange,TargetProductName)