Thanks Frank

Below are the three different approaches I tried:


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

=SUMPRODUCT((AP8128:AP24510=BE8128)*(AR8128:AR2451 0))

=SUMIF($AP$8128:$AP$24510,$BE8128,$AR$8128:$AR$245 10)


They all return: #VALUE!







-----Original Message-----
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

.


.