Hi
Harlan's formula should work even if you have leading/trailing
characters in your source data. Could you post the EXACT formula you
have tried and what the returned result was

--
Regards
Frank Kabel
Frankfurt, Germany

"KENNY" schrieb im Newsbeitrag
...
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

.