Excel: find a word in sentences then use it's number


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


This question generated 16 answers. To proceed to the answers, click here.

This thread is current as of October 17, 2014.


For more resources for Microsoft Excel