On Mar 24, 5:24*pm, Max wrote:
=SUMIF(A2,"*"&"A1XT-4-0713-01-00021-1.PDF"&"*",C2)
IF A2 contains the string it will pick up the value in column C

But it fails if col C = text. I'd prefer the more generic index/match way
explained in my response which works to return both text or numbers. You had
another earlier posting which bears relevance to this issue. If you use the
more generic index/match instead of SUM conditional functions to perform
lookup-n-return, then it doesn't matter what the return col may contain
(text, nums or mixed data). It'll work right through.
--
Max
Singapore
---

True. Where I use this the "C" always contains a value. Very good
point though.