Sum when text contains

[fireslguk]

I have 2 columns A and B

A contains various amounts in £

B contains various text example

A. B
£2. Jules CaT
£3. Jules 1
£2. Jules
£4. Paper
£2. Jules 3
£1. Jules HcT

So a formula that adds up all when Jules is in column B

Answer would be £10

 

[Sam_D_Ben]

Something like this,

Book1
	A	B	C	D	E
1	A	B
2	£2	Jules CaT		Jules	10
3	£3	Jules 1
4	£2	Jules
5	£4	Paper
6	£2	Jules 3
7	£1	Jules HcT
Sheet2

Cell Formulas
Range	Formula
E2	E2	=SUMPRODUCT((ISNUMBER(SEARCH($D$2, $B$2:$B$7)))*(VALUE(SUBSTITUTE($A$2:$A$7, "£", ""))))

 

[Fluff]

Another option

=SUMIFS(A:A,B:B,"*jules*")