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.

Hi,

Put this in Book 2
A1-A30 Product No's
B1-B30 Sales
A1 is the product you are looking
=SUMPRODUCT(([Book1]Sheet1!$A$1:$A$30=A1)*([Book1]Sheet1!$B$1:$B$30))


Mike

"Eqa" wrote:

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.

You can use SUMIF, like this:

=SUMIF(Sheet1!A:A,A2,Sheet1!B:B)

assuming that your product numbers and sales figures are in columns A
and B of Sheet1, and that your summary list of product numbers begins
in A2 of Sheet2 - put this formula in B2 and copy down.

Hope this helps.

Pete

On Apr 8, 7:56*am, Eqa wrote:
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.