How to SUM multiple LOOKUP results

This is my first post on excelforum, I hope someone can help.

I have a table of 'Product Sales', and every time a product is sold it populates the table with a 'stock code' in one column, and the 'quantity' sold in the next column. The table will contain multiple sales of the same stock code.

I am trying to find a way to 'LOOKUP' every sale of a particular stock code, and return the sum of all the quantities sold of that one stock code.

I think I need to use the LOOKUP function in some way, but if I am way off the mark, please let me know.

Thanks

Al.

Brilliant, works a treat. Thanks very much daddylonglegs.

that's a mosquito....daddylonglegs are spiders.

I stand corrected :-)