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