Thanks for the reply, but no luck
-----Original Message-----

KENNY wrote...
cell BE8128 is a word (I've substituted the actual word
instead of the
cell
reference, to no success.

Column AP Column AR
Dog 100
Cat 50
Dog 120
(Blank) (blank)
Cat 66
...
"KENNY" schrieb
...
=SUMIF($AP$8128:$AP$24510,$BE8128,$AR$8128:$AR $24510)

Try

=SUMIF
($AP$8128:$AP$24510,"*"&$BE8128&"*",$AR$8128:$AR$2 4510)


--
hgrove
----------------------------------------------------------
--------------
hgrove's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=11432
View this thread:
http://www.excelforum.com/showthread...hreadid=319403

.