Assuming your data is in A1:B7. In say A10:A12 you enter a,b&C
respectively. Use this in B10 and copy down to B12.

=SUMPRODUCT(($A$1:$A$7=A10)*$B$1:$B$7)

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=525812