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$24510)


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