=SUMPRODUCT(--(MID(A1:A6,3,1)="X"),(B1:B6))


"Mehta Mehta" wrote in message
...
Hi,

I want to put a sumif formula, but only recognising one character in a
string of text.

For example:

£
CLX75 - 10
CLX69 - 20
CLS65 - 5
CLT12 - 65
CLX59 - 151
CLT60 - 15

I want to return the total via a sumif on those that contained the letter
X
(3 rd character of the text). So the answer would 181.

Can you please help.

Thanks

--
hm