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=512664