find a word in sentences then use it's number

[pmncivil]

hi i need to identify a word like car in a bunch of sentences in a column then sum their numbers into a cell.
i explain it more:

...a sentence which contain car ........	2
...........book..........	4
..................car...............	32
.............car	12

<tbody>
</tbody>

i need to sum those numbers which contain car in their sentences.
like:
sum of cars = 2+32+12
books = 4 + ......
i can use this formula now : e1=is car
sumif(a:a,e1,b:b) but i dont know how to identify car in a sentence then sum of those numbers in new cell. i mean just sum those cells which contain car in their sentence.
i dont know how to explain it better. did u got it or i should have explain it more?
the key word is car or something else in a sentence and i need it's number.
by the way i'm new in excel and i don't know anything about programming.
so plz say in details if there is any solution.
thank u

 

[pmncivil]

I think you need:

=SUMIF(A:A,"*"&E1&"*",B:B)

Sir it does worked. And it was exactly what I need.
Thank u very much.
But I don't get the meaning of those simbles but I really appreciate it

 

[pmncivil]

The * is a wildcard character it indicates that there can be any text before and any text after because it was used before and after E1

Sheet1

	A	B	C	D	E
1	car to michel	5		14	car
2	chair	1
3	car for sara	6
4	book	5
5	car in hospital	2
6	mom's car	1

<colgroup></colgroup><tbody>
</tbody>

Spreadsheet Formulas

Cell Formula D1 =SUMIF(A:A,"*"&E1&"*",B:B) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >>

Thank u for explaining.
Can u tell what does the & do in this formula after the *

 

[pmncivil]

The * is a wildcard character it indicates that there can be any text before and any text after because it was used before and after E1

Sheet1

	A	B	C	D	E
1	car to michel	5		14	car
2	chair	1
3	car for sara	6
4	book	5
5	car in hospital	2
6	mom's car	1

<colgroup></colgroup><tbody>
</tbody>

Spreadsheet Formulas

Cell Formula D1 =SUMIF(A:A,"*"&E1&"*",B:B) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >>

And can u tell me how can I learn all of those wildcard characters and excel functions?
Is there any learning source for that (of course I need free resources)

 

[Scott Huish]

The Excel help file, but there are 2 wildcard characters * which can mean 0 or more characters or ? which means a single character.

So *able would match able, table, constable, detestable, but ?able would only match table from those choices because it's the only 1 that has 1 single character before able.

Can u tell what does the & do in this formula after the *

The & is the concatenation operator so it make it like this, so if CAR was in E1
"*"&E1&"*" would evaluate as *CAR*

 

[pmncivil]

Wow that was really good answer sir.
But i didnt understand excel help it was too simple and there arent complete enough for most of my problems.
There are many things in it but I just need programming simbols and funtions.
I would be glad if someone send me another help resource link.

And by the way my problem is solved. Thank u scott and the others who helped.

 

[Scott Huish]

Overview of formulas - Excel

Maybe:
Microsoft Excel Tutorials - FunctionX