=SUMIF(a1:a4, "cat",b1:b4)
or
=SUMIF(a1:a4,c1,b1:b4)
so that you can enter cat or rabbit in c1
--
bill k
------------------------------------------------------------------------
bill k's Profile:
http://www.excelforum.com/member.php...nfo&userid=821
View this thread:
http://www.excelforum.com/showthread...hreadid=401319