Hi,

I need to add up some values depending what is in the cell next to
them

A B
1 Cat 2
2 Dog 3
3 Cat 5
4 Rabbit 6

So i need to add up all the numbers in colum B that are next to cat -
is this possible?

Thanks,


--
babygoode
------------------------------------------------------------------------
babygoode's Profile: http://www.excelforum.com/member.php...o&userid=26109
View this thread: http://www.excelforum.com/showthread...hreadid=401319