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