Combining Totals of like Items

[AFuturePrez]

I am working with a multiple sheet Excel workbook. I have multiple
inventory items and would like the totals of items with like UPCs and
lot codes. I have many instances where items may have similar UPC but
different lot codes. It is important that these items be segragated by
UPC AND Lot code? Is there an easy and efficient way to do this?
Thanks.

 

[RagDyer]

Normally, when a particular function is recommended as a solution to a
question, an additional comment is always included to "read the Help files".

In this case however, *don't* read the XL Help files on SUMPRODUCT().

Read Bob Phillips' web page on the function instead:

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Sumproduct should do exactly what you want, and Bob's treatise on the
function will show you how to accomplish it.