Assuming you don't really need plurals on sheet 2 (apples and pears vs. apple
pear,) then try this formula:
=SUMIF(Sheet1!$A$1:$A$4,A1,Sheet1!$B$1:$B$4)
If you truly need to need them to be plural then try this array entered
formula (cntl-shift-enter rather than just enter):
=SUM(IF(Sheet1!$A$1:$A$4 & "s" = A3,Sheet1!$B$1:$B$4,0))
--
Kevin Vaughn


"Aniab" wrote:


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