I have two sheets. one contains a list of item IDs in the first column and
number of hits in the second column. The second sheet contains a list of item
IDs in the first column (the item ID may appear more then once within the
column) and the units shipped in the second column. The reason an ID may be
listed more then once is because each entry represents a different salkes
order where the ID appeared and the quantity shipped next to it represents
the quantity shipped on that particular order.

The problem I am having is figuring out a way to put a formula in the "hits"
column of the first sheet that would look up the ID from that same sheet and
count the total number of orders that ID shipped on from the second sheet.
All zeros should be omitted since they represent an order that did not ship.

Any suggestions?

Thanks.