use SUMIF

=SUMIF(A1:A5,"A1",B1:B5) or

=SUMIF(A1:A5,C1,B1:B5)

where C1 is the cell you type the product code you want to sum

HTH
--
Pls provide your feedback by clicking the Yes button below if this post have
help you. This will help others to search the archives for result better.


Thank You

cheers, francis









"Fraser B" wrote:

but i would like to search through a list of product codes that have product
quantities next to them.

i would like excel to automatically add together the quantities of matched
product codes.

for example if i had A1:- 20, A2:- 30, A3:- 20, A1:- 35, A3:- 35

then it would summaries the information to read

A1:- 55
A2:- 30
A3:- 55

hope this makes sense.

Many thanks in advance.

fraser