Finding the sum of cells that have specific values in the adjacent cell!

[stmur]

I think this will be one of those "Duh, of course.." ones, but here goes:

I have a list of data:

2	140
1	660
10	140
0.92	660
2	130
0.18	660
4	510
0.44	820
4	510

<colgroup><col style="width:48pt" span="2" width="64"> </colgroup><tbody>
</tbody>

I want to have a formula that finds the sum of the values in Col 1 (Qty) for the rows that equal, eg: 140, in Col 2 (Product)
So that I can have a list of Products of the Qty that relates to each product.
(there are products in increments of 10 from 10 to 920, that is, 92 products)

Hope this makes sense!
thanks in advance

 

[shg]

See Help for the SUMIF function.

 

[stmur]

Sorry, Excel isn't my strong point!

How do I get it to Sum the values from Col 1 based on the Col 2 value?
I can see how to sum the number of times the value is repeated, but....?