In one workbook I have a list of product Nos. with corresponding sales
figures next it . The same product No. could be listed multiple times with
different sales values next to it. In a second workbook I have a list of
product Nos. some of which appear in book 1. What I would like to know is
what formula do I use to look at the Product items in book 2 and then look at
the at the list in book1 and add the sales figures together for the matching
product Nos. I hope this all clear. Thanks in anticipation.