Lookup and sum on multiple repeating values.

I have tried sorting this out myself but have run aground! Any help is much appreciated.

(I need to do this without removing duplicated or using a pivot table, so I think I need to use sum and lookup in an array form possibly?)


I have two columns. One has a list of product Id's with some repeated values, the other is numeric values.

A B
ProductBall 2
ProductBall 3
ProductGizmo 6
ProductGadget 7
ProductGadget 1

I need a formula that looks up repeated values(product names) in column A and sums the values in column B if column a names are identical. So the above table would yield this:

A B
ProductBall 5. <--- I need solely the formula for this cell.
ProductGizmo 6
ProductGadget 8


Thanks again if anyone has insight!
Tristan

Offhand two ways come to mind. 1 would be to create a pivot table.
another would be to copy the cells from column A into another location (for example column D) then use the remove duplicates function in excel, then use this formula to sum the dups in columns A and B... =sumif(A:A,D1,B:B) (this assumes you put your copied values in column D)

Mystic... yes. I'd generate a list of product codes in E2, using this formula, copied down:

=IFERROR(INDEX($A$2:$A$6,MATCH(0,INDEX(COUNTIF($E$1:$E1,$A$2:$A$6),0),0)),"")

and SUMIF in F2, copied down:

=IF(E2="","",SUMIF(A:A,E2,B:B))

And the same file, with a pivot table.