Thanks max, that did it.

Sorry to everyone else for my info being vague!

"Max" wrote:

Try sumproduct ..

Eg: =SUMPRODUCT((A2:A100="hit")*B2:B100)
will return the sum of numbers in col B where col A contain the key text: hit

And if the key text: hit
could be part of a text string, eg: hit man, double hit, etc
you could use instead:
=SUMPRODUCT(ISNUMBER(SEARCH("hit",A2:A100))*B2:B10 0)

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"carol" wrote:
Is it possible to use the VLOOKUP or IF function to firstly, search a column
for a particular word, then return the corresponding values from another
column and calculate multiple values if more than one word hit is found?