This is what I'm trying to accomplish:
Lets say one sheet has this data:
Apple 10
Apple 10
Apple 12
Pear 23
I'd like to be able to have a function on sheet 2 that sums ALL the
numbers linked to the Apples:
Apples 32
Pears 23
etc.
I tried with VLookup, but it only returns a single value. Is there any
way to make it to return the whole sum?

Thanks.


--
Aniab
------------------------------------------------------------------------
Aniab's Profile: http://www.excelforum.com/member.php...o&userid=31374
View this thread: http://www.excelforum.com/showthread...hreadid=510696