So You'd need a formula that locates all duplicate names in the Product
column, delete all but first row of duplications while placing the sum of all
Duplicate's Value Column cells in the Value Column... I'm very sorry that I
have no idea about anything technical in Excell but I thought maybe if
someone sees this variation, it might help to clarify Your needs... Good luck
*smiles*

"cj21" wrote:


Guys i posted this the other day but no-one came up with an answer, they
suggested a pivot table but i dont have time to learn them. Any body got
an answer.

I have a list of products and corresponding values as follows:

Product Value
01 10
01 12
01 16
02 41
02 17
03 4
03 5

I want a formula that adds up the values for each cattogry. In
otherwords i want a new table like:

Product Value
01 38
02 58
03 9


Any formula for this?

Thanks for the help

Chris


--
cj21
------------------------------------------------------------------------
cj21's Profile: http://www.excelforum.com/member.php...o&userid=25673
View this thread: http://www.excelforum.com/showthread...hreadid=513200